Microsoft Office Tutorials and References
In Depth Information
Working with Tables
If applying table styles isn’t working, it’s probably because the range was already formatted before you converted it
to a table. Table formatting doesn’t override normal formatting. To clear existing background i fill colors, select the
entire table and choose Home ➪ Font ➪ Fill Color ➪ No Fill. To clear existing font colors, choose Home ➪ Font ➪ Font
Color ➪ Automatic. To clear existing borders, choose Home ➪ Font ➪ Borders ➪ No Borders. After you issue these
commands, the table styles should work as expected.
If you’d like to create a custom table style, choose Table Tools ➪ Design ➪ Table Styles ➪ New
Table Style to display the New Table Style dialog box. You can customize any or all of the 12
items in the Table Element list. Select an element from the list, click Format, and specify
the formatting for that element. When you’re ﬁ nished, give the new style a name and click
OK. Your custom table style will appear in the Table Styles gallery in the Custom category.
Unfortunately, custom table styles are available only in the workbook in which they were
If you want to make changes to an existing table style, locate it in the Ribbon and right-click. Choose Duplicate from
the shortcut menu. Excel displays the Modify Table Style dialog box with all the settings from the specii ed table
style. Make your changes, give the style a new name, and click OK to save it as a custom table style.
Working with Tables
This section describes some common actions you’fill take with tables.
Navigating in a table
Selecting cells in a table works just like selecting cells in a normal range. One difference is
when you use the Tab key. Pressing Tab moves to the cell to the right, but when you reach
the last column, pressing Tab again moves to the ﬁ rst cell in the next row.
Selecting parts of a table
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 Row and the Total Row, if it has one). You can also press Ctrl+Spacebar (once
or twice) to select a column.