Chapter 5: Introducing Tables
105
Tip
If you would like 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 Quick Style dialog box with all the settings
from the specified table style. Make your changes, give the style a new name, and click OK to save it as a cus-
tom table style. n
Working with Tables ........................................................................................................
This section describes some common actions you’ll 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, and when you reach the last col-
umn, pressing Tab again moves to the first 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.l (^) 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.
l 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.
l (^) 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 entire table (including the Header Row and the
Total Row). You can also press Ctrl+A (once or twice) to select the entire table.
Tip
Right-clicking a cell in a table displays several selection options in the shortcut menu. n
Adding new rows or columns ..................................................................................
To add a new column to the end of a table, select a cell in the column to the right of the table and
start entering the data. Excel automatically extends the table horizontally.