Wednesday, January 11, 2012

How to Insert Excel Data Into a Word 2007 Table


1. Open the Microsoft Word and Excel 2007 files. Locate the files from both software programs on the computer hard drive and double click on the file icon to open each.
2. Create the table in the Word document. Choose the 'Insert' tab and from that menu ribbon select 'Table' option. Next, choose the appropriate size of the table to insert in the Word document.
3. Highlight the data in Microsoft Excel to insert in the Word 2007 table. Left click the mouse and while holding the mouse button down, highlight the data in Microsoft Excel.
4. Copy the data from the Excel document. With the data highlighted, right click and choose 'Copy' from the right click menu.
5. Paste the data from the Excel document into the Word table. Select the word document and position the cursor inside the Microsoft Word 2007 table. Then, choose 'Paste Special' from the main menu in the paste dropdown box. From the paste special dialogue box choose the 'Microsoft Excel Worksheet Option' and insert the data into the table.
6. Save and close both documents when done. From the main file menu, choose 'Save' in both Microsoft Excel and Word to make certain the work is not lost.

Blogger news