How to insert Multiple Blank Rows in Excel at once

Microsoft Excel ever fascinates me amongst its awesome features which assist us create lots of stuff easily. If you lot are dealing amongst a lot of information in addition to every bit it keeps on changing, you lot mightiness come upwards across a province of affairs where you lot postulate to insert multiple blank rows inwards Excel at once. You mightiness know a unmarried agency to insert 1 or 2 blank rows inwards Excel, simply what if you lot desire to insert multiple blank rows inwards Excel betwixt data? We cannot follow the procedure of inserting unmarried row multiple times every bit it is really tedious.

In this article, I volition allow you lot know how to insert multiple blank rows inwards Excel at 1 time easily in addition to amongst less effort. I volition demo you lot 2 ways of doing it. First, allow us encounter how nosotros tin insert a unmarried blank row inwards Excel which close of us know.

Normal agency of inserting unmarried blank row inwards Excel

Hover the mouse on the row publish where you lot desire to insert a blank row. Here, I desire to insert a unmarried row at row 4. So, I hovered the mouse pointer on row iv in addition to you lot could encounter a dark arrow, in addition to hence click on it to choose the row.

Next correct click on the selected row in addition to click on ‘Insert’ option in addition to this would insert a unmarried blank row inwards Excel. This is useful entirely when you lot postulate to insert a unmarried blank row in addition to cannot move followed to insert multiple blank rows inwards Excel. So, below are 2 slow ways explaining how to insert multiple blank rows inwards Excel at once.

Insert Multiple Blank Rows inwards Excel past times selecting Rows

This method allows you lot to insert multiple blank rows inwards Excel past times selecting rows. Let me explicate inwards details. Let us say, I desire to insert v to vi blank rows, in addition to hence I postulate to choose that many rows.

For example, I desire to insert vi rows afterward row 3, in addition to hence hover the mouse pointer at row three (You tin encounter the dark arrow) in addition to choose the row.

Next, click in addition to concur the left mouse push in addition to choose vi rows.

Now, right-click on the selected expanse in addition to choose ‘Insert’ option. This would insert an equal publish of blank rows matching the publish of selected rows. But, this method is used entirely if you lot desire to insert few numbers of rows every bit nosotros cannot choke along on selecting 1000s of rows to insert one 1000 rows using this method.

Then how tin you lot insert 1000's of multiple blank rows inwards Excel? The adjacent method helps you lot to create so. 

Insert Multiple Blank Rows inwards Excel using Name Box

This method allows you lot to insert multiple blank rows inwards Excel fifty-fifty inwards 1000s. Just caput over to Name Box in addition to plough over values inwards the format ‘starting row: ending row’. For example, if you lot desire to insert one 1000 rows from row 4, in addition to hence plough over 4:1003 in addition to hitting enter.

Then it would choose one 1000 rows from row 4.

Next, correct click on selected rows in addition to click on ‘insert’ option. This would inset one 1000 multiple blank rows from row 4.

These are 2 uncomplicated in addition to slow ways to insert multiple blank rows inwards Excel at once. If you lot convey anything to add, in addition to hence delight create allow me know inwards comments.

Read next: How to brand the best role of Name Box inwards Excel.

Source: https://www.thewindowsclub.com/

Share This :