Word 2007-inserting excel spreadsheets

  • Thread starter Thread starter tinks
  • Start date Start date
T

tinks

Hi,
What is the most efficient way to insert an excel spreadsheet into to Word
2007 document
 
Hi,

To copy a range of cells (which can be a complete worksheet) from an Excel
spreadsheet into your Word document, copy the cell or cells to the clipboard.
Then in Word, place the cursor where you want the Excel cell or cells to be
displayed, press Alt+Ctrl+V, which opens the Paste Special dialog box,
select the Paste Link checkbox, and select the option that is best for you.
"Microsoft Office Excel Worksheet Object" will bring over a copy of how it
looks in Excel, borders/formats included. "Unformatted Unicode Text" will
bring over the number without any formatting. This procedure creates a LINK
field, which be updated if the Excel spreadsheet is modified.

You can also create a LINK field to an Excel file without selecting a range
of cells. To do this, on the Insert tab, in the Text group, click Object. On
the Create from File tab, enter the name of the Excel file and select Link to
file.
 
tinks,

Note that with Paste Special, you can also choose to paste a link as
"Formatted Text (RTF)" which will basically produce a Word table linked to
Excel data.

Which option is the best really depends on what you are trying to
accomplish.
 
Back
Top