Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
Fortunately, the Delete dialog box forces you to
decide how the remaining cells should fill in the
gap created by your deletion, by offering four
logical choices. Here are the steps:
Wait a minute, aren’t columns and rows cells?
Sure they are. But they’re finite groups of cells,
with fixed arrangements. You select an entire
row by clicking its row number, or an entire
column by clicking its column letter. Each of those
clicks selects hundreds (or thousands, in the case
of a column) of cells and when deleted, Excel
needs only move everything next to the selected
row or column over (or up) to fill the gap.
1. Select the cell or range of cells you want to
2. Right-click the selection and choose Delete...
from the pop-up menu. Note that this is
different than the plain “Delete” command
from the previous section on deleting rows
and columns. Because a single cell or a
manually-selected range of cells is selected, a
variation on the Delete command is offered,
including the ellipsis, indicating a dialog
box will follow. As shown in Figure 5-16, the
Delete dialog box appears.
But what if you want to delete a block of cells,
say the block shown in Figure 5-15? Because it’s
not an entire row or column, Excel can’t just
make a quick “fold” in the worksheet to bring
the remaining parts back together. The presence
of content in surrounding cells makes it even
more complex—if not for Excel, for you, because
you need to know what you’d like Excel to do
with the content that remains after the deletion.
Four choices await you when you choose Delete
(with the ellipsis) from the pop-up menu.
3. Choose how you’d like Excel to make the
deletion. You can:
An unwanted range of cells can be removed
with relative ease—you just need to know
how you’d like Excel to go about it.
Shift cells left
Shift cells up
Delete the entire row
Delete the entire column
4. Click OK to perform the deletion. Excel will
move the adjacent cells’ content into the
remaining cells, per your instructions in
the dialog box.