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

  1. In Word, select the table you want to import into Excel.

  2. Click the Home tab.

  3. Click the Copy button.

  4. In Excel, click the cell in which you want the upper left table cell to appear.

  5. Click the Home tab.

  6. Click the Paste button.

    Bring Word Data into Excel

Copy Excel Data to Word

  1. In Excel, select the cells you want to export.

  2. Click the Home tab.

  3. Click the Copy button.

  4. In Word, click the location where you want the pasted cells to appear.

  5. Click the Home tab.

  6. Click the Paste button.

    Copy Excel Data to Word
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.148.103.210