Reply
 
Thread Tools Display Modes
  #1   Report Post  
Krohm
 
Posts: n/a
Default excel formula table into word

How do I transfer an excel table into word and not lose the formulas? The
formuals contain simple math (multiplication).
  #2   Report Post  
Shauna Kelly
 
Posts: n/a
Default

Hi Krohm

Do you mean that you want the Word document to display, for example = 2 + 2,
instead of 4?

If so, in Excel, do Tools Options. On the View tab, tick Formulas. You may
have to adjust the column widths to enable the formulas to be seen properly.
Now, select the range that you want to copy. Hold down Shift, and click Edit
Copy Picture. Choose "As shown when printed".


Now, in Word, choose Edit Paste Special and paste as a picture.

If this isn't what you need, experiment with the various combinations of
copying from Excel and Edit Paste Special till you get what you need.


Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Krohm" wrote in message
...
How do I transfer an excel table into word and not lose the formulas? The
formuals contain simple math (multiplication).



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros - Keyboard Commands Janet Microsoft Word Help 6 April 11th 05 05:28 AM
Locking Two Words Together to Make a Proper Compound Noun in Word WorkingWoman Microsoft Word Help 2 April 7th 05 02:33 PM
In Word, how can I see all files (*.*) in "save as"? citizen53 New Users 8 April 4th 05 04:56 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM


All times are GMT +1. The time now is 05:15 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"