Microsoft Office Tutorials and References
In Depth Information
Exporting Excel data to Word
5
Click cell C2; click the Data tab, and then click Subtotal (
) located in the Outline
group. The Subtotal dialog box appears.
You can select where to add the subtotal and the
function to perform in the Subtotal dialog box.
6
Click OK. Excel displays the total for each state and the grand total.
7
Click the Save button on the Quick Access Toolbar, but do not close this document
because you will use this in the next exercise.
Exporting Excel data to Word
After creating an Excel worksheet, you might want to include the Excel data in a Word
report. Excel lets you export Excel data to a Word document. You can perform a simple
replication of data, or you can export Excel tools with the data, so you can make changes
after you have exported it.
Exporting data
You can export Excel data to a Word document. If you then want to make changes, you
can use the Word tools to edit and format the data. In this exercise, you’ll use the Copy and
Paste commands.
1
Launch Microsoft Word. Word displays a blank page.
2
Select File > Save As. Word displays the Save As dialog box.
3
Navigate to the Excel07lessons folder.
4
In the Save As text box, type excel0705_exported , and then click Save.
5
In the Excel based excel0705_done worksheet, click the data in cells A1, B1, and C1 and
drag down to row 21.
Search JabSto ::




Custom Search