Add Rows in Excel Shortcut

Shortcut Keys to Add Rows in Excel

Shortcut to add rows in excel we have a simple key i.e. Ctrl and + sign. If your keyboard has a number pad to the right of the keyboard then you can use Ctrl and + sign but if you don’t have a number pad then you need to press the excel shortcut key Ctrl and Shift and = sign.

When it comes to excel, the basic ingredients are cells, rows, and columns. One should be well versed with these three elements to work well in excel. In this article, we will show you one of the important methods of adding rows in using the shortcut keys.

Add-Rows-in-Excel-Shortcut

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Add Rows in Excel Shortcut (wallstreetmojo.com)

How to Add Rows in Excel using Shortcut Keys?

You can download this Shortcut To Add Rows Excel Template here – Shortcut To Add Rows Excel Template

When we work with MS Excel, one of the major tasks of adding or deleting the rows and columns, so you should be well versed with these aspects and shortcut is the way to go forward.

The reason we are talking about shortcuts is that it will increase productivity, and jobs will be done quickly than manual efforts. Hence, shortcuts are the key elements to increase your productivity in excel.

Example #1

Add Rows in Excel Shortcut Example 1

Now for an example, look at the below data in excel worksheet.

  1. Before adding a new row, it is quite important to know where we need to add the row; let’s say we need to add a row after the 3rd row, then first we need to select the row after the 3rd row.

    Add Rows in Excel Shortcut Example 1.1

  2. Now right-click on the 4th row(Midmarket) and select the “Insert” option.

    Add Rows in Excel Shortcut Example 1.3

  3. It will show the below option dialogue box.

    Add Rows in Excel Shortcut Example 1.4.0
    It is quite important to understand this “Insert” dialogue box. We have four options: “Shift cells right, Shift cells down, Entire row, Entire column.”

  4. As of now, we have the option selected “Shift cells down” click on “Ok” and see what happens.

    Add Rows in Excel Shortcut Example 1.5
    Because we have selected the option of “Shift cells down,” it has shifted the selected cell to the down cell but not the entire row, so whenever you do this operation, it is important to remind about this. If this goes unnoticed, all the data will be wrongly organized.

  5. Because we have selected the option of “Shift cells down,” it has shifted the selected cell to the down cell but not the entire row, so whenever you do this operation, it is important to remind about this. If this goes unnoticed, all the data will be wrongly organized.

    Add Rows in Excel Shortcut Example 1.6

  6. Since we are inserting a new row all together, we need to choose “Entire Row” in the “Insert” dialogue box. Now click on “Ok.”

    Add Rows in Excel Shortcut Example 1.7

  7. It will shift the entire row data to the below row by adding a new row in the selected row cell.

    Add Rows in Excel Shortcut Example 1.8

Now for an example, you want to insert one more row. You need not perform all these actions again; instead, you can press the F4 key by selecting the row you want to push below.

Add Rows in Excel Shortcut Example 1.9

You must be wondering how this has happened. This is because of the function key “F4”. This function key will repeat the previous set of activities performed in the worksheet.

Example #2

The above might be confusing because of four options in the “Insert” window to show you an easy method now. Rather than just selecting the row cell to select the entire row only.

  • Step 1: To select the entire row, press the shortcut key Shift + Space key, and it will select the entire row you.

Shortcut Key to Select Entire Row:

Add Rows in Excel Shortcut Example 1.16
Example 1.10
  • Step 2: Now press the shortcut key Ctrl & Plus sign, and it will insert a new row you by pushing the selected row to the below row.

Shortcut Key to Add New Row:

Add Rows in Excel Shortcut Example 1.15
Add Rows in Excel Shortcut Example 1.11
  • Step 3: Now, similarly, press the F4 function key to repeat the previous action performed in excel. So the number of times you press the F4 key the number of times it will insert the new row for you (if any other action is not performed after inserting the row).
Example 1.12

Example #3

Insert More than One Row

What if you want to insert multiple rows at once? We cannot do this numerous times. So, we have a technique to encounter this as well.

  • Step 1: For example, if you want to insert three rows at once, select those many rows first.
Add Rows in Excel Shortcut Example 1.13
  • Step 2: Now, press the shortcut key and see the magic.
Example 1.14

So, as soon as you press the shortcut key, it has pushed all the selected rows down, and those many new rows are inserted. Like this, by using shortcut methods, we can insert rows at will.

Things to Remember Here

  • Shortcut key may vary from keyboard to keyboard; if the keyboard has a number pad, then we can press Ctrl & Plus sign or else we need to press Ctrl & Shift & Equal sign.
  • F4 function repeat the previous action.
  • We can insert as many rows as we have selected before pressing the shortcut key. If you select two rows, then two rows will be inserted, and if you have selected three rows, then three rows will be inserted, like this it works.

Recommended Articles

This has been a guide to Add Rows in Excel Using Shortcut keys. Here we discuss shortcut keys for adding rows in excel along with examples and a downloadable template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>