How to insert multiple rows or columns into your Spreadsheet 5


How to insert multiple rows or columns into your Spreadsheet

 

There are going to be times when working with your spreadsheets you’ll need to insert a new row or a new column into your data. But what happens if you need to insert more than one row or column. What would you do if you had to insert 50 or more new rows or new columns into your spreadsheet. Yes you could insert them one at a time, but that would be very tedious and not mention a waste of your precious time. Luckily, there’s an easy way to accomplish this task in Excel.

 

The following video steps you through the process of how to insert multiple rows or columns into your spreadsheet, or if you prefer you can read through the step-by-step instructions shown below the video.

 

 

 

 How to insert multiple rows or columns into your spreadsheet

 

Easily insert multiple rows or columns into your Excel spreadsheets Click To Tweet

 

Step by step instructions:

 

Insert a single row

Step 1 Left click on the row number of the row immediately below where you want to insert the new row.

Image of Select row below where you want to insert the new row

Select the row

 

Step 2 Right click on the selected row and then click “Insert”.

image of Right Click and select Insert

Right click then select “Insert”

 

A new row will now have been inserted above the row we selected – row 5 in our example.

image of New row inserted in our spreadsheet

New row inserted above your selected row

 

Insert a single column

Step 1 Left click on the column letter of the column immediately to the right of where you want to insert the new column.

image of Select column to the right of where you want to insert the new column

Select the column

 

Step 2 Right click on the selected column and then click “Insert”.

 

Image of Right Click and select Insert

Right click then select “Insert”

 

A new column will now have been inserted to the left of the column we selected – column C in our example.

image of New column inserted in our spreadsheet

New column inserted to the left of your selected column

 

Insert multiple rows

Step 1 Left click on the row number of the row immediately below where you want to insert the new rows AND drag down the number of rows you wish to insert. In our example below, I am wanting to insert 5 new rows, so I have clicked AND dragged from row 5 down to row 9 (5 rows in total).

image of Select the rows below where you want to insert the new rows

 Select the number of rows you want to insert

 

Step 2 Right click on any the selected rows and then click “Insert”.

image of Right Click and select Insert

Right click then select “Insert”

 

New rows will now have been inserted above the row we selected – 5 rows inserted above row 5 in our example.

image of New rows inserted in our spreadsheet

New rows inserted immediately above your select row

 

Insert multiple columns

Step 1 Left click on the column letter of the column immediately to the right of where you want to insert the new columns AND drag across to the right the number of columns you wish to insert. In our example below, I am wanting to insert 2 new columns, so I have clicked AND dragged from column C across to and including column D (2 columns in total).

image of Select the columns to the right of where you want to insert the new column

Select the number of columns to be inserted

 

Step 2 Right click on any the selected rows and then click “Insert”.

image of Right Click and select Insert

Right click then select “Insert”

 

New columns will now have been inserted to the left of the column we selected – 2 columns inserted to the left of column C in our example.
image of New columns inserted in our spreadsheet

 New columns inserted immediately to the left of your selected column

 

Ok that’s it for this tip, as always should you have any questions or queries about any information I have provided, let me know.

Till next time.

Cheers,
Brian

 

Please Share

If you liked this or know someone who could use it, please click the buttons below to share it with your friends on LinkedIn, Google+, Facebook and Twitter.

 

Download

You can download a PDF transcript of this tip by clicking the following link – How to insert multiple rows or columns into your Spreadsheet.

You can also download a copy of the spreadsheet I used in this article so you can explore this tip further – How to insert multiple rows or columns into your Spreadsheet.

 

 

  • Great tips! Very informative! Thank you!

    • Your welcome Monica, hope you are able to use the tip in your spreadsheets

  • Your welcome Monica, hope you are able to use the tip in your spreadsheets.

  • Ursula Petula Barzey

    Great tip. I’ve always done it one by one which definitely wasn’t very efficient!

    • Thanks Ursula. hope this tip saves you some time.