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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
information excel word

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

Information from Excel to Word

ResolvedVersion 2003

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?

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 training courses.

Word tip:

Autonumbering in Word

The Auto Numbering feature in Word can be both useful (when you want it to work) and annoying when you don't.

When you begin a list by typing 1 then press the space bar or tab key, and type in text, Word will automatically change the paragraph to a numbered list when the ENTER key is pressed. This will mean that the next paragraph is automatically numbered as 2.

If you do not want Word to continue sequentially numbering any following paragraphs, you can turn off Auto Numbering. To do this, go to Tools-Auto Correct Options. In the Auto Correct dialog box, click the "Auto Format As You Type" tab. Deselect the "Automatic Numbered Lists" checkbox, then click OK to close the box.

To turn Auto Numbering back on, go back into Tools-AutoCorrect Options and recheck the "Automatic Numbered Lists" option.

View all Word hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.