excel formula table into word

G

Guest

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

Shauna Kelly

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".
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create formulas in a table, using Word? 1
[Excel 2011] Insert lines in table with formuals and formatting preserved 8
equations in Word 2007 4
Inserting a formula into a Word Table 2
Summary table for track changes 0
How to display row numbers when pasting Excel data in Word? 2
formulas copying from sheet to sheet 6
Working with Excel worksheet in Word document 1

Top