Microsoft® Excel® 2010 Inside Out

Using Excel Tables in Word Documents

You can create tables directly in Word, of course, but if your tables consist of more than a few rows or columns, you’ll probably find it simpler to build them in Excel and then transfer them to your Word documents. You can use either of the following methods to move a worksheet range from Excel into Word:

• Copy the Excel data to the Clipboard, and then use Paste or Paste Special in Word to paste the table in the format of your choice, with or without a link to the source data.

• On the Insert tab in Word, click Object. The Object command in Word works just like its counterpart in Excel. (See Embedding and Linking with the Object Command on page 958.)

Pasting an Excel Table from the Clipboard

If you copy an Excel ...