Microsoft Office Tutorials and References
In Depth Information
Formatting a Table
Just as you do when entering a formula in Excel, begin your entry in the Formula box with
an equal sign. You can then use cell and range references, constants, mathematical
operators, and functions from the Paste Function list to complete the formula. For more
information, see “Using Formulas and Functions” on page 356.
Word has four range names that you won’t find in Excel: ABOVE, BELOW, LEFT, and RIGHT.
With these ranges, you can create a formula that includes all the cells in the direction you
specify. For example, to display the total of the values in a column, in a row at the bottom
of the column you would insert the formula =SUM(ABOVE).
INSIDE OUT Use an Excel table for more demanding calculations
As noted, the formula capabilities of Word don’t compare favorably with those of Excel.
If you need text functions, date calculations, or more advanced mathematical
calculations, you need to use Excel. That doesn’t mean that you can’t include the data and the
resulting calculations in your Word document, however.
You insert an Excel worksheet into your document in much the same way you insert
a table: on the Insert tab, click Table, Excel Spreadsheet. While you work in the Excel
spreadsheet, you have the full capabilities of that program. In fact, the ribbon changes
to show the same tabs and tools you see in Excel.
To include more or fewer Excel columns and rows in your Word document, drag the
borders of the Excel object. When you click outside the worksheet, the Excel interface
(such as row and column headings) disappears, and the Word ribbon returns.
Doubleclick in the worksheet to resume editing in Excel.
Formatting a Table
The table you get when you use the Insert Table or Convert Text To Table command is not
much to look at: a simple grid of thin black lines, with text aligned at the top and left of
each cell. With a few simple commands on the Design and Layout tabs under Table Tools
(see Figure 8-8), you can quickly spruce up the table’s appearance.