Coffee Break Computer

Paste Expandable Excel Data into Word 2007

This is how to paste data from Excel into Word when you want the pasted data to expand when the original data does. When you paste a link to a block of cells in an Excel worksheet, the data in Word will update when the Excel data changes, but it won’t show any added columns or rows. This technique will cause the pasted data in Word to expand in size if the original data in Excel does.

How to Paste Expandable Excel Data into Word

1. In Excel, select the range of cells to paste. You’re going to apply a range name to that block of cells.
2. To name the range, click the Name Box on the Formula bar and type in the name to use. Enter to finish. Note: Range Names can’t have spaces in them, but you can use an underscore or period to separate words.
3. Push Ctrl + C to copy the selected range.
4. In Word, move the cursor to where you want the Excel data, then push Ctrl + Alt + V. (Or in the Home tab, Clipboard group, click the down-arrow on the Paste button and choose Paste Special.)
5. In the Paste Special box, select Paste link: and MS Office Excel Worksheet Object. OK to finish.

If you want to test it, go back to Excel, and insert a column or row into the data, and you should see it immediately update in Word.

Popularity: 4% [?]