Excel 2000 in a Nutshell

Name

Insert → Rows

Synopsis

This is a quick method for inserting new rows in your worksheet. Make sure you have selected a cell in the row below where you want the new row inserted before selecting Insert → Rows. As the new rows are inserted, the rows below are moved down. To insert multiple rows simultaneously, simply select the desired number of rows before selecting Insert → Rows. As shown in Figure 6-2, where cells B4-B7 are highlighted you only need to highlight one cell in each row to indicate the number of rows you want to add. When Insert → Row is selected, four blank rows will be inserted above row 4. The new rows are always added above the active cell. The active cell is the first cell that was selected, in Figure 6-2, this cell is the one in the selection that is not highlighted (cell B4).

Figure 6-2. Highlight the number of rows you want to insert. Excel will add four new rows about between the Interest Rate and Monthly Payment rows