Microsoft Office Tutorials and References
In Depth Information
Adjusting Columns and Rows
3. Make your choice between shifting the
surrounding (and selected) cells to the right or
down or inserting an entire row or column.
4. Click OK. If you’re not happy with the results,
remember that you can undo your actions
(choose Edit > Undo or Ctrl+Z) and try again.
Deleting Columns and Rows
Do you have a row or column (or more than one)
that you wish weren’t there? Maybe you added
too many, or you left too many blank rows or
columns between sections of your worksheet.
It’s easy to get rid of them, whether they have
content or not. Perhaps too easy, if there is
content in them, so be careful before applying
any of the following methods for column or row
deletion—there could be content somewhere
beyond the range of cells you can see, and you
might not want to lose whatever that content is.
The Delete command applies to whatever’s
selected—a column or a row—and deletes its
content as well as the cells themselves.
As tempting as it would be to delete a
column and a row at the same time, Excel
won’t let you do that. If you attempt it,
a prompt appears, indicating that you
cannot delete the content of overlapping
cells. Another thing that doesn’t work?
The Delete key, which only deletes the
content of selected cells, not the cells
(columns or rows) themselves.
That warning out of the way, here are some simple
ways to remove unwanted columns or rows:
Right-click. Select the unwanted columns
or rows, and right-click. From the resulting
menu, shown in Figure 5-14, choose
Delete button. Select the unwanted
columns or rows, and click the Delete
button (don’t bother with the drop-down
menu, just click the button itself) on the
Home tab’s Cells group.