2007 Microsoft® Office System Plain & Simple

Analyzing a Word Table in Excel

You can use Microsoft Office Word to generate professional-looking tables that present your data cleanly and clearly. However, Word isn’t the best tool for summarizing and analyzing that data. If, after you’ve created a table in Word, you realize that you need to do a bit more analysis of the data, take it to the data-analysis expert: Excel.

Analyze the Table

1. In Word, on the Home tab, select the table, and click the Cut button (or press Ctrl+X).

2. Switch to a blank Excel worksheet, and, on the Home tab, click the Paste ...