Microsoft Office Tutorials and References
In Depth Information
Deleting Columns and Rows
Adding and Moving
Columns or Rows
You need to be careful when you use the Insert Copied Cells feature. Because you’re
shifting only certain parts of your worksheet, it’s possible to mangle your data,
splitting the information that should be in one row or one column into multiple rows or
columns! Fortunately, you can always back out of a tight spot using Undo. Figure
15-12 shows the sort of problem you could encounter.
Figure 15-12:
Top: Here, two price cells
($43.99 and $3.00) were copied
and pasted before the picture
was taken, and the existing
price cells were shifted down to
accommodate the new entries.
But the prices now no longer
line up with the appropriate
item names, which is probably
not what you want.
Bottom: It makes much more
sense to use the Insert Copied
Cells command when you’re
copying a whole row’s worth
of data. Here’s worksheet
where two new rows have
been pasted, and Excel politely
moves the original set of items
out of the way.
Deleting Columns and Rows
In Chapter 14, you learned that you can quickly remove cell values by moving to the
cell and hitting the Delete key. You can also delete an entire range of values by
selecting multiple cells and hitting the Delete key. Using this technique, you can quickly
wipe out an entire row or column.
However, using delete simply clears the cell content. It doesn’t remove the cells or
change the structure of your worksheet. If you want to simultaneously clear cell
values and adjust the rest of your spreadsheet to fill in the gap, you need to use the
Home Cell Delete command.
For example, if you select a column by clicking the column header, you can either
clear all the cells (by pressing the Delete key) or remove the column (by choosing
Home Cells Delete). Deleting a column in this way is the reverse of inserting a
column. All the columns to the right are automatically moved one column to the
left to fill in the gap left by the column you removed. Thus, if you delete column B,
column C becomes the new column B, column D becomes column C, and so on. If
you take out row 3, row 4 moves up to fill the void, row 5 becomes row 4, and so on.
Search JabSto ::

Custom Search