How to Insert Row in Excel

If you find it hard to figure out how to insert a row into an Excel table, you’re in the right place! After reading this tutorial, it’ll be child’s play.

Let’s start, shall we?

See the video tutorial and transcription below:

See this video on YouTube:

From time to time, we forget to enter or we just need to add some data into an already prepared table.

For situations like these, Excel has a useful function of inserting an empty row or even multiple rows within a table.

The Easiest and the Quickest Way How to Insert Row in Excel

And here again, Excel offers more than one solution. Now we’re gonna go through one only, and it’ll be the easiest, the quickest one.

Let’s say we need to insert an extra row right below row 4, an extra row for an employee called Patrick.

How to Insert Row in Excel - insert row under the other row

How can you get it done?

Look at the vertical bar on your left showing the row numbers and simply click on one row below number 4 – row 5. Right-click and select ‘Insert’.

How to Insert Row in Excel - insert option

Done! Excel has added an empty row 5 right below row 4, just as we wanted. All you need to do now is just fill in Patrick’s details.

How to Insert Row in Excel - add empty row

And here’s a handy tip for you.

How to Add More Rows at Once

If you want to add more rows at once, you don’t need to do it one by one.

Let’s say we want to add three empty rows below row 8. This is the trick.

As you already know, Excel adds extra rows above the selected part. Therefore, we’ll click one row down from the place where we want to add rows. In this case, we’ll select row 9.

How to Insert Row in Excel - adding more rows at once

Then we click and hold the left button on the mouse and drag it three rows down. You always see the number of selected rows in this small box below the cursor, so you don’t need to lose your time counting them tediously. This way you give a command to Excel on how many empty rows to add.

How to Insert Row in Excel - insert more rows at once

And we carry on as before – right-click on the selected rows and choose ‘Insert’.

How to Insert Row in Excel - more empty rows

By following these steps, you can add as many rows as you need.

How to Insert Row in Excel - added empty rows

If you’d like to know more on how to manage rows in Excel, watch the next tutorial!

Don’t miss out a great opportunity to learn:

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!