excel word

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel & word

Excel & word

resolvedResolved · Low Priority · Version 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:

Closing all your workbooks Quickly

Hold the SHIFT key down and using the mouse click on the file menu, it will now now CLOSE ALL rather than close. This closes all workbooks down but still leaves the application open.

View all Excel hints and tips


Server loaded in 0.09 secs.