How to insert Multiple Blank Rows in Excel at once

Microsoft Excel all the time fascinates me with its superior options which assist us do a lot of stuff simply. If you might be coping with a variety of information and because it retains on altering, you would possibly come throughout a scenario the place you want to insert a number of clean rows in Excel at once. You would possibly know a single approach to insert one or two clean rows in Excel, however what in order for you to insert a number of clean rows in Excel between information? We can’t observe the method of inserting single row a number of occasions as it is vitally tedious.

In this text, I’ll let you know the way to insert a number of clean rows in Excel at once simply and with much less effort. I’ll present you two methods of doing it. First, allow us to see how we will insert a single clean row in Excel which most of us know.

Normal approach of inserting single clean row in Excel

Hover the mouse on the row quantity the place you need to insert a clean row. Here, I need to insert a single row at row four. So, I hovered the mouse pointer on row four and you might see a black arrow, then click on on it to choose the row.

how to insert multiple blank rows in excel at once - How to insert Multiple Blank Rows in Excel at once

Next proper click on on the chosen row and click on on ‘Insert’ possibility and this might insert a single clean row in Excel. This is beneficial solely whenever you want to insert a single clean row and can’t be adopted to insert a number of clean rows in Excel. So, beneath are two simple methods explaining how to insert a number of clean rows in Excel at once.

Insert Multiple Blank Rows in Excel by deciding on Rows

This methodology permits you to insert a number of clean rows in Excel by deciding on rows. Let me clarify in particulars. Let us say, I need to insert 5 to 6 clean rows, then I want to choose that many rows.

For instance, I need to insert 6 rows after row three, then hover the mouse pointer at row three (You can see the black arrow) and choose the row.

Next, click on and maintain the left mouse button and choose 6 rows.

1518356639 454 how to insert multiple blank rows in excel at once - How to insert Multiple Blank Rows in Excel at once

Now, right-click on the chosen space and choose ‘Insert’ possibility. This would insert an equal variety of clean rows matching the variety of chosen rows. But, this methodology is used solely in order for you to insert few numbers of rows as we can’t carry on deciding on 1000s of rows to insert 1000 rows utilizing this methodology.

Then how are you going to insert 1000’s of a number of clean rows in Excel? The subsequent methodology helps you to accomplish that. 

Also Read: Stop Microsoft Word from marking Contractions as errors

Insert Multiple Blank Rows in Excel utilizing Name Box

This methodology permits you to insert a number of clean rows in Excel even in 1000s. Just head over to Name Box and provides values in the format ‘beginning row: ending row’. For instance, in order for you to insert 1000 rows from row four, then give four:1003 and hit enter.

1518356639 156 how to insert multiple blank rows in excel at once - How to insert Multiple Blank Rows in Excel at once

Then it might choose 1000 rows from row four.

Next, proper click on on chosen rows and click on on ‘insert’ possibility. This would inset 1000 a number of clean rows from row four.

These are two easy and straightforward methods to insert a number of clean rows in Excel at once. If you will have something to add, then please do let me know in feedback.

Leave a Comment