Choosing Table Options in Office 2011 for Mac
New for Word and Excel in Office 2011 is the ability to use table styles to format text and table cells, an ability that PowerPoint gained in Office 2008. You get many attractive, built-in styles from which to choose. In Word and Excel, you can create your own styles and add them to your collection.
Next to the New button in the Table Options group of the Ribbon of Word and Excel are check boxes that affect how your table displays. If your window isn’t widened enough, you might not see the buttons. In this case, click the Options button to display the same options:
Header Row: When selected, this option displays the header row.
When this option is selected in Word and PowerPoint, special formatting is applied to the header row. When selected in Excel, you see special formatting with filter buttons that when clicked, activate the Filter dialog.
Total Row: When selected, this option displays a row at the bottom of the table that can be used for the results of calculations on data in the table.
In Word, Excel, and PowerPoint, the Total row can be formatted. In Word, you can use Word fields to perform calculations on data in table cells.
In Excel, you can use the power of Excel formulas to put calculation results into the Total row. To display the pop-up menu, click into any cell in the Total row and click the formula button that appears. Then choose a formula from the pop-up menu.
Banded rows: Displays or hides color bands for rows.
First Column: Highlights the first column in the table.
Last Column: Gives the last column in the table a highlight color.
Banded Columns: Displays or hides color bands for columns.