• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Using Programs Together > Combining Word and Excel

Combining Word and Excel

Word and Excel work well together, especially when you're creating Word documents that display structured numerical data. The previous sections explained how to copy and link Excel data into Word documents. In this section, you'll learn how to do the reverse—copy a Word table into an Excel worksheet. Later in this chapter, we'll cover copying text from Word into Excel and PowerPoint.

To copy a Word table into Excel

1.
In Word, click any cell within the table you intend to copy.

2.
Choose Table > Select > Table.

The table is selected (Figure 26.12).

Figure 26.12. To select a table in Word, click any cell of the table and choose Table > Select > Table.


3.
Choose Edit > Copy or press .

4.
Switch to Excel and select the cell in which the Word table will start.

5.
Choose Edit > Paste or press .

The Word table is pasted into the Excel document. Adjust the column widths as necessary to fully display the contents of each column (Figure 26.13).

Figure 26.13. The Word table appears in the Excel worksheet.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint