How to insert Multiple Blank Rows in Excel at once

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 single row multiple times as it is very tedious.

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 two ways of doing it. First, let us see how we can insert a single blank row in Excel which most of us know.

Normal way of inserting 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.

insert Multiple Blank Rows in Excel

Next right click on the selected row and click on ‘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 two easy ways explaining how to insert multiple blank rows in Excel at once.

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 details. Let us say, I want to insert 5 to 6 blank rows, then I need to select that many rows.

> Ad

<

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.

insert multiple blank rows in excel by selecting 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 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. 

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.

insert multiple blank rows in excel at once

Then it would select 1000 rows from row 4.

Next, right click on selected rows and click on ‘insert’ option. This would inset 1000 multiple blank rows from row 4.

These are two 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 comments.

Read next: How to make the best use of Name Box in Excel.

Posted by on , in Category Office with Tags
Sridhar is a Software Engineer who loves to stay updated with developments in the world of technology. He is fond of writing everything related to Internet, Computers and Mobile and Desktop Operating Systems.