Microsoft Office Tutorials and References
In Depth Information
Deleting rows or columns
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.
When the cell pointer is in the lower 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 the 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
or Column 2. Normally, you 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) to be deleted. 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
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 (in the same workbook or in a different workbook):
1. Press Alt+A twice to select the entire table.
2. Press Ctrl+X to cut the selected cells.
3. Activate the new worksheet and select the upper left cell for the table.
4. Press Ctrl+V to paste the table.
Sorting and filtering a table
The header row of a table contains a drop-down arrow that, when clicked, displays sorting and
filtering options (see Figure 159-1). When you filter a table, rows that don’t meet the filter criteria
are temporarily hidden and are not included in summary formulas in the total row.
Search JabSto ::

Custom Search