Exchanging Table Data between Excel and Word
Just as you can create workbooks to store and manipulate financial and other data in Excel, you can use Word to create reports and other text documents to interpret and provide valuable context for your worksheet data. Word documents can also present data in tables, which are arranged in rows and columns like a worksheet. For example, if you receive a report from a traveling colleague in which she created a table listing the prices of popular products at a competitorâs store, you can copy the data from the Word document to an Excel worksheet for direct comparison. You can also go in the opposite direction, copying Excel data to a table in Word.
Bring Word Data into Excel
In Word, select the table you ...
Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
