Part I: Getting Started with Excel
106
Similarly, if you enter data in the row below a table, Excel extends the table vertically to include
the new row.Note
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. and the data will not be part of the table. n
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:l (^) Table Columns to the Left
l Table Columns to the Right
l (^) Table Rows Above
l Table Rows Below
Tip
When the cell pointer is in the bottom-right cell of a table, pressing Tab inserts a new row at the bottom of the
table, above the Total Row (if the table has one). n
When you move your mouse to the resize handle at bottom-right cell of a table, 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 Column1,
Column2, and so on. Typically, you’ll want to change these names to more descriptive labels. Just
select the cell and overwrite the generic text with your new text.
Deleting rows or columns........................................................................................
To delete a row (or column) in a table, select any cell in the row (or column) to be deleted. To
delete multiple rows or columns, select a range of cells. Then right-click and choose Delete ➪
Table Rows (or Delete ➪ Table Columns).Moving a table .........................................................................................................
To move a table to a new location in the same worksheet, move the mouse pointer to any of its
borders. When the mouse pointer turns into a cross with four arrows, click and drag the table to
its new location.To move a table to a different worksheet (which could be in a different workbook), you can drag
and drop it as well — as long as the destination worksheet is visible onscreen.