Shortcut Keys to Add Rows in Excel

For example, even after you have created a table in Excel, you want to add additional rows. With the help of shortcut keys – Ctrl + Plus sign or Ctrl + Shift + Plus sign, one can insert it easily. Even if you have added the new cells within the existing range or adjacent to the table, they will automatically be formatted to go well with the current table style.

The essential ingredients are cells, rows, and columns for Excel. One should be well versed in these three elements to work well in Excel. This article will show one of the essential shortcut keys methods to add rows.

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

How to Add Rows in Excel using Shortcut Keys?

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

We are talking about shortcuts to increase productivity and do jobs quicker than manual efforts. Hence, shortcuts are the key elements to increasing your productivity in Excel.

Example #1

Now, suppose we want to insert one more row. We need not perform all these actions again. Instead, we can press the F4 key by selecting the row you want to push below.

  • Before adding a new row, it is essential to know where to add it. Let us say we need to add a row after the 3rd row. First, we need to select the row after the 3rd row. Right-click on the 4th row (Midmarket) and select the “Insert” option. It will show the below option dialog box. It is essential to understand this “Insert” dialog box. We have four options: “Shift cells right,” “Shift cells down,” “Entire row,” and “Entire column.” We have selected the option “Shift cells down,” and click on “OK” to see what happens. Since 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, it is essential to remind yourself about this whenever you do this operation. If this goes unnoticed, it will wrongly organize all the data. Since we are inserting a new row, we must choose “Entire row” in the “Insert” dialog box. Now click on “OK.” It will shift the entire row data to the below row by adding a new row in the selected row cell.

It is essential to understand this “Insert” dialog box. We have four options: “Shift cells right,” “Shift cells down,” “Entire row,” and “Entire column.”

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

Example #2

The above example might be confusing because there are four options in the “Insert” window to show you a straightforward method. 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. It will choose the whole row for you.

Shortcut Key to Select Entire Row:

  • Step 2: Now, press the shortcut key Ctrl + Plus sign. It will insert a new row for you by pushing the selected row to the below row

Shortcut Key to Add New Row:

  • Step 3: 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 #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.

  • Step 1: For example, select those many rows first if you want to insert three rows at once.

  • Step 2: Now, press the shortcut key and see the magic.

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

Things to Remember Here

  • The shortcut key may vary from keyboard to keyboard. If the keyboard has a number pad, we can press the Ctrl + Plus sign, or we need to press the Ctrl + Shift+ Plus sign.The F4 function repeats the previous action.We can insert as many rows as selected before pressing the shortcut key. For example, if you choose two rows, it will insert two rows, and if you have chosen three, it will insert three.

This article is a guide to Add Rows in Excel Shortcut. Here, we discuss how to add rows in Excel shortcut and its two methods, examples and an Excel template. You may learn more about Excel from the following articles: –

  • Excel Pivot Table Add ColumnInsert Shortcut in ExcelRows Excel FunctionHow to Sum Multiple Rows in Excel?Status Bar in Excel