2 Methods to insert more than one columns and rows in Excel

Rows and columns plays an important role to filling different type of data in any active worksheet. Sometime during working in any worksheet you need to insert more than one columns and rows in Excel. There are lot of novice users have to face difficulty to quickly insert more than one columns and rows in Excel.

There are different version in which most of the users are working on daily basis to prepare different kind of reports. If you are working on Excel 2007 or above then you by default you have 1 to 1048536 rows and A to XFD (16384) columns in a worksheet. When you insert any new worksheet then by default you have same number or rows and columns. You can quickly insert more than one columns and rows in Excel.

Must Read: Latest VLookup trick to search with more than one criteria in Excel

How to insert more than one columns and rows in Excel

During working in Excel, sometime we need to insert one or more rows and columns. Lot of novice users have to face difficulty to solve this problem or take help to other experienced user. It is a simple trick which helps all novice users to quickly insert more than one columns and rows in Excel. In this guide we have to discuss 2 methods to quickly insert more than one columns and rows in Excel, lets have a look.

2 Methods to quickly insert more than one columns and rows in Excel

Method 1: With the help of Insert command

Insert command allows you to quickly insert one or more cells, rows or columns in active worksheet. To to quickly insert more than one columns and rows in Excel you have to take given simple steps.

Step 1: Select one or more rows and columns in active worksheet.

Step 2: Click on the Home tab > Click on the Insert drop down arrow. You will get different option now, you have to choose required option as per your need. You can also press right mouse button on selected rows or columns and choose “Insert…” option from the cascading menu.

Insert Cells: This option allows you to insert more than one cells in active worksheet.
Insert Sheet Rows: This option helps you to quickly insert one or more rows in active worksheet.

Must Read: Quick methods to get age from birthdate in Microsoft Excel

Insert Sheet Columns: If you want to insert one or more than one columns then you have to chose this option.
Insert Sheet: This option allows you to insert new worksheet in active workbook.

Note: All new rows are inserted at the top of selected rows while all new columns are inserted at the left side of selected column. If you insert one or more cells then rest of the cells are shifted in right, down or entire row/column.

Method 2: With the help of Shortcut Key

This is another an interesting and quick method which allows you to quickly insert more than one columns and rows in Excel. Excel shortcut helps you to do this job without any extra effort.

Step 1: Select one or more rows and columns in active worksheet.

Step 2: Press Ctrl+ Shift+ + shortcut key. You can also Shift+F10 shortcut key to open the cascading menu and choose “Insert…” option.

Step 3: In the “Insert” dialog box choose required option as per your need.

I hope this guide is useful for all those guys who want to learn different methods to quickly insert more than one columns and rows in Excel. If you have any suggestion regarding this guide then please write us in the comment box. Thanks to all.

Leave a Reply

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