Ten Minute Guide to Excel 97

Inserting Cells

Sometimes you will need to insert information into a worksheet, right in the middle of existing data. With the Insert command, you can insert one or more cells or entire rows or columns.

Shifting Cells

Inserting cells in the middle of existing data will cause the data in existing cells to shift down a row or over a column. If your worksheet contains formulas that rely on the contents of the shifting cells, this could throw off the calculations (see Lessons 14 and 15). Double-check any formulas in your worksheet that might be affected.

To insert a single cell or a group of cells, follow these steps:

1. Select the cell(s) where you want the new cell(s) inserted. Excel will insert the same number of cells as you select.

2. Open the Insert ...