3 Quickest Ways to Insert Rows in an Excel Spreadsheet

Download Article

Insert rows fast with a keyboard shortcut or the Quick Access toolbar

Co-authored by wikiHow Staff

Last Updated: November 6, 2024

Download Article

• Inserting Rows on a Mac
|
• Inserting Rows on Windows
|
• Inserting Rows with the Quick Access Toolbar

|Show more |Show less

This wikiHow teaches you how to insert rows in Excel using shortcuts on a Windows or Mac computer. There are keyboard shortcuts as well as custom shortcuts that you can use in Excel spreadsheets.

Adding Rows in Excel Using a Shortcut

1. Open an Excel spreadsheet on your PC or Mac.
2. Click a row number to select it.
3. Press CTRL + Shift + + to insert a row below.

Steps

Method 1

Method 1 of 3:

Inserting Rows on a Mac

Download Article

1. 
   1
   Open an excel spreadsheet. You may use an old one or create a new one.
2. 
   2
   Select a row by clicking on the row number. You should see the row number on the far left of the sheet. The new row will appear above the selected row or rows.

   • Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.
   Advertisement
3. 
   3
   Type the Control+⇧ Shift++ keys at the same time to insert a row. Your new row should appear above the selected one.

   • If you have no rows selected and press Control+⇧ Shift++ then it will not work.
Advertisement

Method 2

Method 2 of 3:

Inserting Rows on Windows

Download Article

1. 
   1
   Open an excel spreadsheet. You can use an old or new one.
2. 
   2
   Select a row. The new row will be inserted above the selected one. This happens only if you have one row selected.

   • Highlight the same number of rows as you want to add. So to add one row, highlight just one row, to add 2, highlight 2 rows, etc.
3. 
   3
   Type Control+⇧ Shift++ at the same time to insert a row. The new row will appear above the selected one.

   • This shortcut only works if you have a row selected.
Advertisement

Method 3

Method 3 of 3:

Inserting Rows with the Quick Access Toolbar

Download Article

1. 
   1
   Open Excel. The icon is green with a white “X” in it.
2. 
   2
   Open an excel document. It can be an old or new document.
3. 
   3
   Click on the Home tab.
4. 
   4
   Select a row by clicking on the row number. You should see the row number on the far left of the sheet.
5. 
   5
   Click on Insert. It is located near the top right of the Excel window. This should automatically insert a new row above the row you selected. To save the insert row command as a shortcut, do the following:

   • Right-click on Insert Row to open up an additional drop-down menu.
   • Select Add to Quick Access Toolbar. If you have nothing added to your toolbar then the next key will be assigned to F4. Press F4 whenever you want to add a new row.
Advertisement

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Tips

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!