How To Insert Rows In Excel

Uh oh, did you forget to add a row (or several) into your spreadsheet? In this article, we will show you how to easily insert rows into your Excel spreadsheet.

How To Insert A Row In Excel

Last Updated on

The ability to insert rows in Excel is one of its more basic but essential features, so it’s well worth knowing to help your way around a set of data or spreadsheet you’re editing. In this article, we will show you how to add rows to your spreadsheet quickly and efficiently.

1

How To Insert A Single Row Into A Spreadsheet

Adding a single row into your spreadsheet is easy, and the overall process will take you less than 30 seconds.

Once you have learned how to do it once, you will likely never forget how to.

Step

1

Click On The Row Above Where You Want To Insert A Row

When the spreadsheet is open and accessible, click on the row above the one where you want to insert the new row.

You can do this by left-clicking on the number to the left of the row.

Step

2

Right-Click The Row Above Where You Want To Insert A Row

Next, you will want to right-click on the row above where you want to place the new one.

A context window will appear, and you will be given a list of options to choose from.

Step

3

Select Insert

Select the ‘Insert’ option from the context window. A row will then be added below the row that you selected.

2

How To Insert Multiple Rows Into A Spreadsheet

You may think that adding numerous rows to your spreadsheet will take more time and effort, but it actually only takes the same number of steps as adding a single row.

Step

1

Highlight The Number Of Rows Intended To Add

Highlight the multiple rows below where you wish to put the new rows once the spreadsheet is open and accessible, by left-clicking and dragging across.

The same amount of rows as you intend to insert should be highlighted.

Step

2

Right Click On The Highlighted Rows

Once they have been highlighted, right-click on the rows. A context window will then appear on your screen.

Step

3

Click Insert To Add

The number of rows you highlighted will be added above the rows you selected when you click ‘Insert.’

3

How To Insert Non-adjacent Rows Into A Spreadsheet

Lastly, here are four quick and easy steps to adding non-adjacent rows into your spreadsheet.

This is just as simple as adding adjacent rows, and takes the same amount of time to do.

Step

1

Press And Hold Control (Ctrl) And Select Rows With Mouse

When inserting nonadjacent rows, you will need to click and hold the control (Ctrl) key on your keyboard while selecting each of the rows with your mouse.

Step

2

Right-Click The Highlighted Rows

Once you have highlighted all the nonadjacent rows that you would like to use, right-click the rows, and a context window will appear on your screen.

Step

3

Click Insert

Click ‘Insert’, and the rows will then be added to your spreadsheet.

Final Thoughts

All in all, it is incredibly easy to add rows into your spreadsheets, whether you need to add one or multiple rows at a time. It’s an essential skill, but even experienced Excel users may not know how to add rows to Excel in multiple or non-adjacently. Luckily, now you do.

You might like this

Find out how to count cells in Excel with our guide - and several useful methods
Are you trying to make your Microsoft Excel sheet easier to read for others?
Are you trying to make your spreadsheet more readable for Excel’s formulas? Here's how
Avoid typing errors by using the autofill setting to add dates to Excel

Share this article

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Managing Editor
at
PC guide
Kevin has been a technophile since he first owned a Commodore 64. Then an Amiga….progressing to Gameboy, self-built systems, consoles, and a 15-year career in and around computing and technology. Kevin is an all-around tech and gadget enthusiast. He was previously found at such places as Micro Mart, Custom PC, Bit-tech, and PC PRO, then Which? Computing, Den of Geek, and Daily Telegraph. Also WIRED, Hardware Heaven, and KitGuru.

Independent, transparent, rigorous and authentic, our reviews are the most thorough and honest in PC gaming. Learn about our review process.

Leave a Comment