How to Insert Multiple Blank Rows in an Excel 2007 Worksheet

A fast way to insert a blank row in a Microsoft Excel worksheet is to click on the row number that is below where you want the blank row inserted, right-click, and click Insert.

Don't click in a cell, but on the row numberat the very left of the worksheet. The entire row will highlight.

By default, Excel always inserts a blank row above the row that has been selected when following this procedure.

This works quickly if you want to add one blank line or row to a spreadsheet. But if you want to insert many blank rows, this wastes time ... and can give you a wrist cramp!

If you want to know how to quickly insert multiple rows, we provide two methods below. The first method takes a bit of set-up time, but is a faster to use if you need to insert multiple rows often. The second method is not quite as quick to use, but requires no setup.

Method One for Inserting Multiple Rows

1. In your Excel document, click the little arrow after the Quick Access Toolbar in the upper right corner. See image above.
2. Click More Commands down near the bottom of the dropdown list as shown in the image.
3. Click Insert Sheet Rows from the list and click Add. Then click OK.

There is now a new icon added to the Quick Access toolbar in the upper left corner of the Excel window as shown below.

To insert multiple rows any time in the future, click on the on the row number that is below where you want the blank row inserted and click the Insert Sheet Rows icon as many times as needed. Pretty neat, huh.

Method Two for Inserting Multiple Rows

1. In your Excel document, insert a row the usual way by clicking on the row number below where you want the blank row inserted, right-click, and click Insert.
2. Then immediately press the F4 key as many time as you need extra rows inserted.

►  Take a look at some of our related Excel posts, such as How to Display All Formulas in an Excel Worksheet