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


What Changes Did I Make In that Template?

When you make changes that affect a template, Word usually asks you if you want to save those changes when you exit the ...

Discover More

Fixing a Numeric Keypad Key

We all expect the keyboard keys to operate as normal, and when they don't, it can be bothersome. Geraldine had such a ...

Discover More

Hyperlinks No Longer Work in a Workbook

Hyperlinks can be a great timesaver and very convenient. Unless, of course, if they don't work as you expect. This tip ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA 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 8 + 2?

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.