Page 202 - Excel Timesaving Techniques for Dummies

39_574272 ch34.qxd 10/1/04 10:53 PM Page 187
34 Quick and Easy
Insertion and

Deletion
Technique

his technique looks at insertion-and-deletion editing that goes
Save Time By beyond the mere cell level — where you’re limited to just replacing
Tor deleting a cell’s particular contents. Here you get a look at larger
Safely inserting cells into
(and removing them from) insertions and deletions that involve structural changes to the worksheet
existing ranges or workbook.
Inserting and deleting These larger edits include inserting new cells into — or deleting them
entire rows and columns from — existing ranges. It also shows how to insert new rows and
from the worksheet columns into a worksheet and how to (safely) delete existing ones.
Finally, it looks at inserting new sheets into a workbook and deleting
Inserting and deleting
entire worksheets form the ones you no longer need.
the workbook
Inserting and Deleting Cells

in an Existing Range

Sometimes, after building your spreadsheet, you have to modify its struc-
ture slightly by inserting new cells for additional entries in an existing
range. To insert new cells without replacing the cells that already have
existing entries, just use the Insert➪Cells command and then indicate
whether Excel is to shift the cells down or to the right to make room for
the new blank ones.
Figures 34-1 and 34-2 illustrate this situation. Figure 34-1 shows a work-
sheet that tracks home sales for a parcel known as Paradise Estates. In
this case, I need to insert three additional house sales into Column B, in
between the $175,000 figure in Row 4 and the $125,000 figure in Row 5.
To do this, I select the cell range B5:B7 (which is where I want the new
entries to appear), open the Insert dialog box (Insert➪Cells), select the
Shift Cells Down option button (Shift Cells Right is selected by default),
and then click OK.