Microsoft Office Tutorials and References
In Depth Information
Working with Tables
h 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.
h 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.
h 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.
Right-clicking a cell in a table displays several selection options in the shortcut menu.
Adding new rows or columns
To add a new column to the end of a table, just 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 is when the table is displaying a
Total row. If you enter data below the Total row, the table will not be extended.
To add rows or columns within the table, right-click and choose Insert from the shortcut menu.
The Insert shortcut menu command displays additional menu items that describe where to add
the rows or columns.
When the cell pointer is in the bottom-right cell of a table, pressing Tab inserts a new
row at the bottom.
Another way to extend a table is to drag its resize handle, which appears in the lower-right
corner of the table (but only when the entire table is selected). When you move your mouse pointer
to the resize handle, the mouse pointer turns into a diagonal line with two arrow heads. Click and
drag down to add more rows to the table. Click and drag to the right to add more columns.
When you insert a new column, the Header row displays a generic description, such as Column 1,
Column 2, and so on. Normally, you’ll want to change these names to more descriptive labels.
Deleting rows or columns
To delete a row (or column) in a table, select any cell in the row (or column) that you want to
delete. If you want to delete multiple rows or columns, select them all. Then right-click and
Table Rows (or Delete