Microsoft Office Tutorials and References
In Depth Information
entire table (including the Header row and the Total row). You can also press Ctrl+A (once or twice) to se-
lect 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 en-
tering 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 be-
low the Total row, the table will not be extended. To add a new row to a table that's displaying a Total row, ac-
tivate the lower-right table cell and press Tab.
To add rows or columns within the table, right-click and choose Insert from the shortcut menu. The Insert short-
cut menu command displays additional menu items that describe where to add the rows or columns.
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.
When you do something with a complete column in a table, Excel remembers that and extends that “something”
to all new entries added to that column. For example, if you apply currency formatting to a column and then add a
new row, Excel applies currency formatting to the new value in that column.
The same thing applies to other operations, such as conditional formatting, cell protection, data validation, and so
on. And if you create a chart using the data in a table, the chart will be extended automatically if you add new data
to the table.
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 choose Delete ⇒ Table Rows (or
Delete ⇒ Table Columns).
Moving a table