excel formula table into word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I transfer an excel table into word and not lose the formulas? The
formuals contain simple math (multiplication).
 
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
 
You must log in or register to reply here.

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

equations in Word 2007 4
How do I create formulas in a table, using Word? 1
[Excel 2011] Insert lines in table with formuals and formatting preserved 8
Inserting a formula into a Word Table 2
Summary table for track changes 0
Working with Excel worksheet in Word document 1
How to export table from outlook into ms access table? 0
MS word Find and Replace using Regex - Help required 0

Back
Top