Microsoft Office Tutorials and References
In Depth Information
Deleting cells, columns, and rows
Here are some guidelines for using Delete:
You can delete multiple nonadjacent rows by pressing Ctrl and clicking each
nonadjacent row before clicking Delete. Excel shifts everything below the deleted rows
upward and adjusts any formulas accordingly.
You can delete entire columns by selecting the column heading before clicking the
Home tab and then, in the Cells group, the Delete command. Excel moves everything
to the right of the deleted columns left and adjusts any formulas accordingly.
You can delete multiple nonadjacent selections in one operation as long as you
delete either entire rows or entire columns. You cannot delete entire rows and
columns at the same time, however, because they overlap. The universe would implode.
You can delete partial rows and columns by selecting a cell or cells and clicking
Delete. Excel displays the Delete dialog box shown in Figure 8-13. You can choose the
direction you want to shift remaining cells to ill the gap, or you can choose to
eliminate the entire rows or columns inhabited by the selected cells.
Figure 8-13 Use the Delete dialog box to choose the direction to move cells.
For more information about formulas and cell references, see Chapter 12.