| | Help by Product Find help quickly and easily. How-to Resources 2007 Release Learning Resources Support and Feedback Technical Resources | Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Delete a cell, row, or column from a table
- Select the cells (cell: A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.), rows, or columns you want to delete.
How?
Some parts of a table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.) can only be seen if you display all formatting marks by clicking Show/Hide
on the Standard
toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.).
To select:
A cell
- Click the left edge of the cell.

A row
- Click to the left of the row.

A column
- Click the column's top gridline or border.

Multiple cells, rows, or columns
- Drag across the cell, row, or column.
- Or select multiple items that are not necessarily in order. Click the first cell, row, or column you want, press CTRL, and then click the next cells, rows, or columns you want.
Text in the next cell
- Press TAB.
Text in the previous cell
- Press SHIFT+TAB
The entire table
- In print layout view (print layout view: A view of a document or other object as it will appear when you print it. For example, items such as headers, footnotes, columns, and text boxes appear in their actual positions.), click the table move handle
, or drag over the entire table.
Note You can also select rows, columns, or the entire table by clicking in the table and then using the Select commands on the Table menu, or by using keyboard shortcuts.
- On the Table menu, point to Delete, and then click either Columns, Rows, or Cells.
- If you are deleting cells, click the option you want.
|