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.
