Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Table of Contents
How to Insert Multiple Rows in Excel?
Let’s understand the ways of inserting multiple rows in Excel.
The common principle to go for the glory is “Do the basics right”. This is the golden word we should not forget whatever may be the profession we are in. If the basics are perfect, then going for the glory will be much easier. The reason why I told this because in this article I am going back to the basics, MS Excel.
Adding multiple columns and rows in Excel in one of the basic stuff we have learned early on in our excel learnings. Inserting one row at a time is the easy-peasy job. Inserting multiple rows in Excel on the go is also an easy peasy job if you the tricks and techniques.
Top 5 Useful Methods to Insert Multiple Rows in Excel
Method #1 – Insert Single Row Using INSERT option
In this method, we need to select the entire row and use insert option on the right click of the mouse.
Step 1: Select the entire row.
Step 2: Right click on the Column Heading and select the Insert option.
This would insert the row instantly above the row we have selected.
Method #2 – Using INSERT option
Now we know how to insert a row in between a data. Similarly, we can add multiple rows in excel shortcut on the go.
As usual, we need to select the row first but it depends on how many rows we insert. If we want to insert two rows we need to select two rows and if we want to insert three multiple rows in excel, we need to select three rows and so on.
In the above image, I have selected three rows and now I will right click on the column header and click on insert this would insert three multiple rows in excel in a single shot.
Method #3 – Insert Multiple Rows in Excel using Short Cut
This will take 50% less time than the above method. Follow below steps to add multiple rows in excel Shortcut.
Step 1: Select the cell above you want to insert the row.
Step 2: Now use the shortcut key to select the entire row instantly. The shortcut keyboard key is Shift + Space Bar.
Step 3: Now if you want to insert two to three multiple rows in excel select those many rows by using Shift + Down Arrow key. In the below image I have selected 4 rows.
Step 4: Now click on another keyboard Ctrl + (plus key) shortcut key to insert row in excel.
Cool Technique: Now we have inserted 4 multiple rows in excel. Suppose we need to insert another 4 rows we need to click on Ctrl + if the rows are selected or instead we can use the key F4, which repeats the previous action in excel.
Method 4: Using the name box.
This would help us to add multiple rows in excel instantly. Suppose if we need to insert 150 rows above the cell we have selected will take some time because first, we need to select those many rows first then insert rows in excel shortcut.
Selecting 150 rows instantly is not possible in the above two methods. We can select those many rows by using name box.
Step 1: Select the cell above we need to insert rows.
Step 2: On the name, box mention the row range. In my case, I have mentioned 5:155 because I have to insert 150 rows.
Step 3: After typing the range, hit enter key this would select the cells from 5:155 instantly.
Step 4: Once the range is selected use the Ctrl + shortcut key to insert row in excel. This will insert 150 rows in just a click.
Alternative Shortcut Key to Insert Row in Excel: ALT + H + I + R is another shortcut key to insert row in Excel.
Method 5: Using Copy Paste Method
Microsoft Excel is so flexible man. Can you believe you can insert rows by copy paste method?
Yes! You heard it right; we can insert rows just by copy and paste another blank row.
Step 1: Select the blank row and copy.
Step 2: Now select the cell above you want to insert rows.
Step 3: Once the desired cell is selected, select the number of rows you wish to insert and right click and select Insert Copied Cells.
Case Study: I have data from A1: A10 as shown in the below image.
I want to insert one blank row after every row as shown in the below image.
In this example, I have only ten rows. What if I have to do it for 100 cells? This will take a lot of time. However, I have the coolest technique you ever see.
Follow below steps to learn.
Step 1: Insert serial numbers next to the data.
Step 2: Copy those serial numbers and paste after the last serial number.
Step 3: Now select the entire data including serial numbers and press Alt + D + S.
Step 4: From the dropdown list select the second column and make sure smallest to highest is selected.
Step 5: Now click on Ok. This would instantly insert the blank row after every row.
Wow! Amazing. Probably the coolest and the most intelligent technique you have learned till date 🙂
Things to Remember About Inserting Multiple Rows in Excel
- We need to select the number of rows first based on that we can insert those many rows.
- Once the rows are inserted, we can use the F4 key to repeat the last action and insert as many rows as we want.
- Alt + H + I + R, Ctrl +, is the shortcut key to insert a row in excel.
- Always insert new rows after selecting the entire row (s) first. Otherwise, there are chances that your data may shuffle
This has been a guide to Insert Multiple Rows in Excel. Here we learn how to insert multiple rows in Excel using excel insert shortcuts along with excel example and downloadable excel templates. You may also look at these useful functions in excel –