Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Inserting Rows.

Inserting Rows

by Allen Wyatt
(last updated November 25, 2016)

7

If you want to insert rows in a worksheet, you probably know that you can do so by displaying the Home tab of the ribbon, click the down-arrow under the Insert tool, and then choosing Insert Sheet Rows. This works marvelously for inserting single rows.

If you want to insert multiple rows, you have several choices. First, you can insert a single row by using the tools on the ribbon, as already mentioned. Then you simply press F4 repeat the command and keep inserting rows.

The second method involves selecting rows before inserting. For instance, if you want to insert five rows, select five existing rows in the worksheet, display the Home tab of the ribbon, click the down-arrow under the Insert tool, and then choose Insert Sheet Rows. Excel dutifully inserts five rows in your worksheet, just before the first row you selected.

If you want to insert rows without using the mouse at all, you can use the shortcut Ctrl++ (that means hold down the Ctrl key as you press the plus sign). Quick, easy, and painless!

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6117) applies to Microsoft Excel 2007, 2010, and 2013. You can find a version of this tip for the older menu interface of Excel here: Inserting Rows.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Who Has the File Open?

Open a workbook that someone else is working on, and you won't be able to save your changes back into the same file. Wouldn't ...

Discover More

Reversing a String

Need to reverse all the characters in a string? You can do so by using the function described in this tip.

Discover More

Enabling Filters by Default

Filtering can be a powerful way to work with large amounts of data in a worksheet. If you use filtering quite a bit, you may ...

Discover More

Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!

More ExcelTips (ribbon)

Deleting Every X Rows without a Macro

Grab some info from a source other than Excel, and you may find the need to delete a certain pattern of rows from a ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 1 + 3?

2014-01-06 05:10:32

Shreepad S M Gandhi

@hophead_lwc

Dhanyawaad. (It means Thankyou in Hindi, the national language of India). Well. :).

2 corrections after my recent experience:
1) Pressing '+' only once too resulted in insertion of row as well as column depending on what is selected. You select a row, press Ctrl+, similar for column.
2) It works for plus sign (+) at both places, the numeric pad as well as the main keypad. In the latter case you need to obviously hold down Ctrl+Shift and then press '+' since the plus sign is meant to work after holding down the Shift key.


2014-01-05 20:37:54

Tony

Use any method above to insert 1 row or column, then use Ctrl + y repeatedly to insert additional rows or columns.


2014-01-03 12:23:44

hophead_lwc

I should also add that Ctrl++ also works with columns.


2014-01-03 12:21:46

hophead_lwc

To use the Ctrl++ method, you have to first select the entire row where you want to insert a new row. If you select multiple rows, Ctrl++ will insert that many rows each time. Also...this only worked using the + on the number pad.


2013-12-30 08:49:00

Diane

You can also use the Alt i then r.


2013-12-30 02:29:25

Shreepad S M Gandhi

The Ctrl++ doesn't seem to work. When I press Ctrl+ I instantly get the standard dialogue box with radio buttons for
Shift cells right,
Shift cells down,
Entire Row,
Entire column...

If you mean to inform the same thing, Thanks, but if this is not what you intend, please help me to achieve a row insertion by pressing Ctrl++.
Thanks in advance.


2013-12-28 13:13:05

Jerry

Alternative to using the Insert command on the Home tab: Select one or more rows, right-click within the selection and choose Insert.


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.