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).

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

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

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.