Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. 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 January 12, 2019)


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 or to the right of or under the Insert tool (in the Cells group), 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 or to the right of the Insert tool (in the Cells group) 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, select the entire row (or rows if you want to add multiple rows), and then you can use the shortcut Ctrl++ (that means hold down the Ctrl key as you press the plus sign) and then press enter. Quick, easy, and painless!

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6117) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. 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. ...


Customizing a Toolbar

Toolbars make it easy to quickly access your most common commands. Excel allows you to customize your toolbars so that ...

Discover More

Deleting Freezes Computer

Sometimes a strange object or text may appear in your document, as happened to Sharon. To complicate the situation, her ...

Discover More

Moving a File from One Folder to Another

Folders are a great organizational tool in Drive. One skill you'll need is to move files from one folder to another. ...

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

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

View most recent newsletter.


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. Maximum image size is 6Mpixels. 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 9 - 5?

2014-01-06 05:10:32

Shreepad S M Gandhi


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


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


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

2014-01-03 12:21:46


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


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


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

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.