information excel word
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Word Training and help » Information from Excel to Word

Information from Excel to Word

resolvedResolved · Low Priority · Version 2003

replyReply Mon 6 Jul 2009, 17:01Delegate Charlotte said...

Charlotte has attended:
Word Intermediate course
Excel Introduction course

Information from Excel to Word

If I have a table in Excel using autoformat, does this total reflect when copied over to Word, or do I need to calculate the totals again?

For upcoming training course dates see: Pricing & availability

replyReply Tue 7 Jul 2009, 17:36Trainer Andrew said...

RE: Information from Excel to Word

Hi Charlotte

Thank you for your question. When you copy from Excel and Paste into Word only the data (not the formulas) is copied. So totals won't need to be added in Word if they were included in Excel but the totals won't update to reflect changed values in Word. For this replace the totals with calculated formula fields in your table (Table > Formula)

I hope this helps.

Kind regards,
Andrew

 

Please browse our web site to find out more about
intermediate microsoft word course london and other Microsoft training courses.

Word tip:

WORK menu

To add the Work menu to the menu bar or a toolbar:

On the Tools menu, click Customize, and then click the Commands tab.
In the Categories box, click Built-in Menus.
Click Work in the Commands box and drag it to the menu bar or displayed toolbar.
With the Work menu in place, you can add any open Word document to your list. Here are the options:

To add the current document to the Work menu, on the Work menu, click Add to Work Menu.
To open a document on the Work menu, on the Work menu, click the document you want to open.
To remove a document from the Work menu:
Press CTRL+ALT+- (dash key). Your cursor will look like a large, bold underscore.
On the Work menu, click the document you want to remove.

View all Word hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard