Microsoft Office Tutorials and References
In Depth Information
Let’s Be Clear about Deleting Stuff
Get these cells outta here!
To delete the cell selection rather than just clear out its contents, select
the cell range, click the drop-down button attached to the Delete command
button in the Cells group of the Home tab, and then click Delete Cells on the
drop-down menu (or press Alt+HDD). The Delete dialog box opens, showing
options for filling in the gaps created when the cells currently selected are
blotted out of existence:
✓ Shift Cells Left: This default option moves entries from neighboring
columns on the right to the left to fill in gaps created when you delete the
cell selection by clicking OK or pressing Enter.
✓ Shift Cells Up: Select this to move entries up from neighboring rows
✓ Entire Row: Select this to remove all the rows in the current cell selection.
✓ Entire Columns: Select this to delete all the columns in the current cell
If you know that you want to shift the remaining cells to the left after deleting
the cells in the current selection, you can simply click the Delete command
button on the Home tab of the Ribbon. (This is the same thing as opening the
Delete dialog box and then clicking OK when the default Shift Cells Left button
To delete an entire column or row from the worksheet, you can select the
column or row on the workbook window frame, right-click the selection, and
then click Delete from the column’s or row’s shortcut menu.
You can also delete entire columns and rows selected in the worksheet by
clicking the drop-down button attached to the Delete command button on
the Ribbon’s Home tab and then clicking the Delete Sheet Columns (Alt+HDC)
option or the Delete Sheet Rows option (Alt+HDR) on the drop-down menu.
Deleting entire columns and rows from a worksheet is risky business unless
you are sure that the columns and rows in question contain nothing of value.
Remember, when you delete an entire row from the worksheet, you delete
all information from column A through XFD in that row (and you can see only
a very few columns in this row). Likewise, when you delete an entire column
from the worksheet, you delete all information from row 1 through 1,048,576 in