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
Select the row
Right click then select “Insert”
A new row will now have been inserted above the row we selected – row 5 in our example.
New row inserted above your selected row
Insert a single column
Select the column
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.
New column inserted to the left of your selected column
Insert multiple rows
Select the number of rows you want to 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.
New rows inserted immediately above your select row
Insert multiple columns
Select the number of columns to be inserted
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.
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.