Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel word

ResolvedVersion 2007

Jermaine has attended:
Excel Intermediate course
Excel Advanced course

Excel & word

can you use excel formulas on word documents

RE: excel & word

Hi Jermaine, thanks for your query. The answer is no I'm afraid, the structure of the formulas in Excel is built around cell references, i.e. the structure of the spreadsheet itself, so the formulas are pretty much "hard-wired" in.

However, you can use maths field codes in a Word table to achieve similar results. Create a table with numbers in it and in the bottom cell, under the Quick Parts menu insert a field, and change the category to Equations and Formulas. Then insert an "=" sign and click the Formula button to construct the formula you want.

Hope this helps,

Anthony

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.