How to Insert Multiple Rows or Columns in Excel Spreadsheet

Date:2019-11-12 Author:Cordelia

If you want to insert more than one row or column at a time in Excel, the method is much like the way you add single row or column to your sheet.

1. To insert more than one rows, you can select multiple rows of cells below the place where you want to insert rows. Take this sheet as an example. I’d like to insert 3 rows between the 2nd row and the 3rd row, so the first step is to select the range of cells from the 3rd row to the 5th row.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

2. Right click the selected area and choose Insert.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

3. Select Shift cells down and hit OK.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

4. Then 3 rows have been added to your sheet.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

5. We can also insert columns in the similar way. Select the cells from column C to column E if you want to insert 3 columns between column B and column C.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

6. Right click the selected area and choose Insert.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

7. Select Shift cells right and hit OK.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

8. Now you can check the result.

How to Insert Multiple Rows or Columns in Excel Spreadsheet

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *