Saturday, October 19, 2013

How to Copy and Paste Tables From Excel into Microsoft Word 2003


1. Highlight and copy the table from Excel. Left-click and hold as you highlight the entire table in Excel. Release the mouse button and the table will remain highlighted. Right-click on the highlighted table, and then click on “Copy.”
2. Select the area in Word that you wish to paste the table into. Click on the portion of the document that you wish to paste the table into.
3. Paste the table into Word. Scroll to the Edit tab and then select “Paste.”
4. Choose your table paste attributes. On the lower-right corner of the table you just pasted, there will be a clipboard icon. Click on this to change the table paste attributes. You can choose from the following table paste attributes by clicking on the corresponding radial button: Keep Source Formatting (which will paste that table the same way you copied it), Match Destination Table Style (which will copy the formatting of any existing tables in Word), Keep Text Only (which will only copy the text from the table), Keep Source Formatting and Link to Excel (which will update the table in Word any time you make changes to the same table in Excel) and Match Destination Formatting and Link to Excel (which will match the formatting of any existing Word tables, and update the table as you make changes to it in Excel).

Blogger news