Microsoft Office Tutorials and References
In Depth Information
Working with Tables
Working with Tables
Tip 158 presents a brief overview of Excel’s table feature. This tip provides a few pointers on
working with tables.
Navigating in a table
Selecting cells in a table works just like selecting cells in a normal range. One difference is
apparent when you use the Tab key. Pressing Tab moves the cursor to the cell to the right, but when
you reach the last column, pressing Tab moves the cursor to the first cell in the next row.
Selecting parts of a table
When you move your mouse around in a table, you might notice that the pointer changes its
shape. The pointer shapes help you select various parts of the table:
h Select an entire column: When you move the mouse to the top of a cell in the header
row, the mouse pointer changes to a downward-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.
h Select an entire row: When you move the mouse pointer to the left of a cell in the first
column, 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.
h 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.
Right-clicking a cell in a table displays several selection options on the shortcut menu.
Adding new rows or columns
To add a new column to the right of a table, activate a cell in the column to the right of the table
and start entering the data. Excel automatically extends the table horizontally. Similarly, if you
enter data in the row below a table, Excel extends the table vertically to include the new row.
An exception to automatically extending tables vertically is when the table is displaying a total
row. If you enter data below the totals row, the table isn’t extended.