Microsoft Office Tutorials and References
In Depth Information
For a different set of color choices, choose Page Layout ⇒ Themes ⇒ Themes to select a different document
If applying table styles isn't working, the range was probably already formatted before
you converted it to a table. (Table formatting doesn't override normal formatting.) To
clear the existing background fill colors, select the entire table and choose
Home ⇒ Font ⇒ Fill Color ⇒ No Fill. To clear the existing font colors, choose
Home ⇒ Font ⇒ Font Color ⇒ Automatic. After you issue these commands, the table styles
should work as expected.
You can change some elements of the style by using the check box controls of the Table Tools ⇒ Design ⇒ Table
Style Options group. These controls determine whether various elements of the table are displayed and also
whether some formatting options are in effect:
• Header Row: Toggles the display of the Header Row.
• Total Row: Toggles the display of the Total Row.
• First Column: Toggles special formatting for the first column. Depending on the table style used, this com-
mand might have no effect.
• Last Column: Toggles special formatting for the last column. Depending on the table style used, this com-
mand might have no effect.
• Banded Rows: Toggles the display of banded (alternating color) rows.
• Banded Columns: Toggles the display of banded columns.
• Filter Button: Toggles the display of the drop-down buttons in the table's header row.
Navigating and selecting in a table
Moving among cells in a table works just like moving among cells in a normal range. One difference is when
you use the Tab key. When the active cell is in a table, pressing Tab moves to the cell to the right, as it normally
does. But when you reach the last column, pressing Tab again moves to the first cell in the next row.
When you move your mouse around in a table, you may notice that the pointer changes shapes. These shapes
help you select various parts of the table:
• To select an entire column: Move the mouse to the top of a cell in the Header row, and the mouse pointer
changes to a down-pointing arrow. Click to select the data in the column. Click a second time to select the
entire table column (including the Header and Total row). You can also press Ctrl+spacebar (once or twice)
to select a column.
• To select an entire row: Move the mouse to the left of a cell in the first column, and the mouse pointer
changes to a right-pointing arrow. Click to select the entire table row. You can also press Shift+spacebar to
select a table row.
• To select the entire table: Move the mouse to the upper-left part of the upper-left cell. When the mouse
pointer turns into a diagonal arrow, click to select the data area of the table. Click a second time to select the