Microsoft Excel always fascinates me with its awesome features, which help us do lots of stuff easily. If you are dealing with a lot of data and as it keeps on changing, you might come across a situation where you need to insert multiple blank rows in Excel at once. You might know a single way to insert one or two blank rows in Excel, but what if you want to insert multiple blank rows in Excel between data? We cannot follow the process of inserting a single row multiple times as it is very tedious.
How to insert Multiple Blank Rows in Excel at once
In this article, I will let you know how to insert multiple blank rows in Excel at once easily and with less effort. I will show you the following ways of doing it. First, let us see how we can insert a single blank row in Excel which most of us know.
The normal way of inserting a single blank row in Excel
Hover the mouse on the row number where you want to insert a blank row. Here, I want to insert a single row at row 4. So, I hovered the mouse pointer on row 4 and you could see a black arrow, then click on it to select the row.
Next right click on the selected row and click on the ‘Insert’ option and this would insert a single blank row in Excel. This is useful only when you need to insert a single blank row and cannot be followed to insert multiple blank rows in Excel. So, below are the three easy ways explaining how to insert multiple blank rows in Excel at once.
- Insert Multiple Blank Rows in Excel by selecting Rows
- Insert Multiple Blank Rows in Excel using Name Box
- Insert Multiple Blank Rows in Excel by using a keyboard shortcut
Let’s see all these methods in detail.
1] Insert Multiple Blank Rows in Excel by selecting Rows
This method allows you to insert multiple blank rows in Excel by selecting rows. Let me explain in detail. Let us say, I want to insert 5 to 6 blank rows, then I need to select that many rows.
For example, I want to insert 6 rows after row 3, then hover the mouse pointer at row 3 (You can see the black arrow) and select the row.
Next, click and hold the left mouse button and select 6 rows.
Now, right-click on the selected area and select ‘Insert’ option. This would insert an equal number of blank rows matching the number of selected rows. But, this method is used only if you want to insert a few numbers of rows as we cannot keep on selecting 1000s of rows to insert 1000 rows using this method.
Then how can you insert 1000’s of multiple blank rows in Excel? The next method helps you to do so.
2] Insert Multiple Blank Rows in Excel using Name Box
This method allows you to insert multiple blank rows in Excel even in 1000s. Just head over to Name Box and give values in the format ‘starting row: ending row’. For example, if you want to insert 1000 rows from row 4, then give 4:1003 and hit enter.
Then it would select 1000 rows from row 4.
Next, right-click on selected rows and click on the ‘insert’ option. This would inset 1000 multiple blank rows from row 4.
3] Insert Multiple Blank Rows in Excel by using a keyboard shortcut
Some of you may be wondering if there is a keyboard shortcut to insert multiple rows in Exel at once. Let me explain the keyboard shortcuts. You can use the following two keyboard shortcuts to insert more than one row in Excel at once:
- Alt, I, and R keys
- Ctrl + Shift +
Let’s see how to use these keyboard shortcuts.
Alt, I, R keys
First, let me show you how to use the Alt, I, and R keys to insert multiple rows at once in Excel. Go through the following instructions to know how to use this keyboard shortcut.
- Select the number of rows that you want to insert. For example, if you want to insert 10 rows before row number 40, select the rows from 40 to 49.
- Press and hold the Alt key.
- Do not release the Alt key, and press and release the I key.
- Do not release the Alt key, and press and release the R key.
- Release the Alt key.
After the above steps, press the F4 key to insert the same number of rows again.
Ctrl + Shift +
This method is easier than the above method. Select the number of rows that you want to insert. After that, Press the Ctrl, Shift, and + keys. Press these three keys again to insert the same number of rows again.
These are the three simple and easy ways to insert multiple blank rows in Excel at once. If you have anything to add, then please do let me know in the comments.
Can you insert multiple rows in Excel at once?
Yes, you can insert multiple rows in Excel at once. There are different ways to do that. You can also use the keyboard shortcuts for the same. We have explained all the methods to insert multiple rows in Excel once in this article.
What is the shortcut to insert multiple rows in Excel?
You can insert multiple rows in Excel at once by pressing the Ctrl, Shift, and + keys altogether. First, select the number of rows that you want to insert. After that, press these three keys to insert multiple rows before the selected rows.
Read next: How to make the best use of Name Box in Excel.
