Microsoft Office Tutorials and References
In Depth Information
Inserting an Excel Spreadsheet
Converting Tables to Text
W hat happens when you don’t want a table to be a table anymore? Suppose that
you’ve created a great table for the annual report, but now someone wants
it in text form—no tables allowed. How do you preserve the data and lose the grid?
You can make the change easily. Click the table then select the Layout tab in the Table
Tools. Choose Convert To Text in the Data group. In the Convert Table To Text dialog
box, select the character you want Word to insert to mark the beginning and end of
individual text entries. You might have Word separate your table entries by inserting
commas, paragraph marks, or another character of your choice between them. Click
OK to convert the table to text.
Inserting an Excel Spreadsheet
In situations when you’re working with a lot of numeric data or you need to be able to
perform calculations with that data, you can take advantage of Excel features that are available
to you as you work in Word. When you add an Excel spreadsheet as a table in your Word
document, you have access to the conditional formatting features in Excel, which include
cell styling, table formatting, and more. You can even include the new sparklines feature in
Excel 2010 in your Word document. Here are the steps for including an Excel worksheet in
your Word document:
1. Position the pointer at the location in the document where you want to create
the table.
2. On the Insert tab, choose Table.
3. Click Excel Spreadsheet in the Table list.
An Excel worksheet window pops up over your Word document. The Ribbon changes
to reflect Excel features.
4. Enter your data, create formulas, and apply formats as needed (see Figure 15-5).
5. Return to the Word document by clicking outside the Excel worksheet area.
Search JabSto ::

Custom Search