WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Add Rows in Excel Shortcut

Add Rows in Excel Shortcut

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

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

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

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

Add Rows in Excel Shortcut Example 1

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

Example 1.1

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

Add Rows in Excel Shortcut Example 1.3

  • Step 3: It will show the below option dialogue box.

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Step 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.

Example 1.6

  • Step 5: 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

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

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 –

  • Excel Pivot Table Add Column
  • Insert Shortcut in Excel
  • Rows Excel Function
  • How to Sum Multiple Rows in Excel?
  • Status Bar in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Shortcut To Add Rows Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More