How to Add Multiple Rows and Columns in Excel (Every Possible Way)

The addition of rows and columns in the Excel spreadsheet is a common task in our everyday life. Sometimes we add a single row or column, sometimes the number is more at the same time. It helps us to insert new entities in that datasheet. Excel has several amazing features to add multiple rows and columns at the same in an Excel worksheet. In this article, we will demonstrate to you 4 easy approaches on how to add multiple rows and columns in the Excel dataset. If you want to get familiarized with them, follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


4 Easy Methods to Add Multiple Rows in Excel

For explaining the processes, we consider a dataset of 10 employees of a company and their salary for the first 2 months of any year. The name of those employees are in column B and their income for January and February is in columns C and D respectively. So, we can say that our dataset is in the range of cells B5:D14. We will add 2 rows to our dataset for illustrating the methods. We will add multiple rows and columns in Excel using this dataset in the upcoming sections.


1. Add Rows Using Context Menu

In this method, we will use the right key of our mouse to add two rows to our dataset. The rows will be added after the first row or row 5 of the dataset. The process is given below:

📌 Steps:

  • First of all, select the entire range of cells B6:B7.

  • Then, right-click on your mouse and select the Insert option.

Add Rows Using Context Menu to Add Multiple Rows in Excel

  • A small dialog box entitled Insert will appear.
  • Now, choose the Entire row option.
  • Click OK.

Add Rows Using Context Menu to Add Multiple Rows in Excel

  • You will see that 2 rows are added above the previously selected rows.

Add Rows Using Context Menu to Add Multiple Rows in Excel

Thus, we can say our method worked perfectly.


2. Utilizing Excel Ribbon

Following the process, we will use the Excel built-in features to add two rows to our dataset. The rows will be added after row 5 of the dataset as previously. This is the easiest feature to add rows to the dataset. The steps of this approach are given below:

📌 Steps:

  • First, select the entire range of rows 6 and 7 with your mouse.

  • In the Home tab, go to the Cells group. Click on Insert.

Utilizing Excel Ribbon to Add Multiple Rows in Excel

  • You will see that 2 new rows are added above the previous rows 6 and 7.

Utilizing Excel Ribbon to Add Multiple Rows in Excel

So, we can say that the method worked pretty smoothly.


3. Keyboard Shortcut to Add Multiple Rows

Here, we are going to familiarize you with several Excel keyboard shortcuts. These keyboard shortcuts will help you add multiple rows to your dataset within seconds. For all the cases we will use the same dataset which we have already used in our previous methods. We will add 2 new rows for every shortcut key and those 2 rows will be added above the row which has the information of Ron. The process of all cases describes below step by step:


3.1. Using Ctrl+Shift+‘=’ (Equal Sign)

In the first use of shortcut keys, we will use ‘Ctrl+Shift+=’  to add two new rows in our dataset.

📌 Steps:

  • Select the entire range of rows 6:7 with your mouse.
  • You can also press ‘Shift+Space’ to select the entire row.

  • Now, press the ‘Ctrl+Shift+=’ keys at the same time on your keyboard.
  • For Mac press ‘Command+Shift+=’ to add new rows.

Using Ctrl+Shift+‘=’ (Equal Sign) to Add Multiple Rows in Excel

You will see that 2 new rows are added at our desired position.


3.2. Via Alt+H+I+R

Secondly, the ‘Alt’ key will help us to add two new rows to our dataset.

📌 Steps:

  • To add rows, select the range of cells B6:B7.

  • Press the ‘Alt’ button and release it. As a result, some letters will appear in the Toolbar of your Excel sheet.

Via Alt+H+I+R to Add Multiple Rows & Columns in Excel

  • Now, press H.

Via Alt+H+I+R to Add Multiple Rows & Columns in Excel

  • Then, press I.

Via Alt+H+I+R to Add Multiple Rows in Excel

  • Finally, press R.
  • And you will find 2 new rows is added.

Via Alt+H+I+R to Add Multiple Rows in Excel


3.3. Using Ctrl with ‘+’ (Plus) Key

Thirdly, we will use the Ctrl with ‘+’ to add two new rows.

📌 Steps:

  • For that, select the entire range of rows 6:7.
  • You can also press ‘Shift+Space’ to select the entire row.

  • Now, press Ctrl with the ‘+’(Plus) key at the same.

Using Ctrl+Shift+‘+’ (Plus Sign) to Add Multiple Rows in Excel

Two new rows will be added at our desired position.


3.4. Through F4 Key

Finally, we are going to use the ‘F4’ key to add 2 new rows to our spreadsheet. If you are not using a laptop keyboard then you can use this amazing technique.

📌 Steps:

  • In the beginning, select the range of cells B6:B7.

Through the F4 key Add Multiple Rows in Excel

  • Press the ‘F4’ button on your keyboard and you will get 2 new rows below row 5.

Through F4 Key Add Multiple Rows in Excel

In the end, we can say that all of our keyboard shortcuts worked perfectly and we can add multiple rows to our dataset.

Read More: How to Transpose Multiple Columns to Rows in Excel


4. Insert Multiple Rows in Different Positions Simultaneously

In this procedure, we are going to add multiple rows in 2 non-contiguous rows. To demonstrate this method, we consider the dataset of that 10 employees. At this time, we are going to add the 2 rows below row 5 and row 9. The steps of this approach are given as follows:

📌 Steps:

  • First of all, select the entire row 6 with your mouse.
  • Now, press the ‘Ctrl’ button and select the entire row 10.

  • After that, in the Home tab, go to Cells group. Click on Insert.

Insert Multiple Rows in Different Positions Simultaneously

  • You will find 2 non-contiguous rows inserted above the current row 7 and row 12.

Insert Multiple Rows in Different Positions Simultaneously

Finally, we can say that our procedure worked effectively and we can add 2 non-contiguous rows at our desired location.

Read More: How to Transpose Column to Multiple Rows in Excel (6 Methods)


Similar Readings


4 Ways to Add Multiple Columns in Excel

For illustrating the processes, we consider the dataset of 10 employees of a company and their salary for the first 2 months of any year. The name of those employees are in column B and their income for January and February is in columns C and D respectively. So, we can say that our dataset is in the range of cells B5:D14. We will add 2 columns to our dataset for showing the methods.

In this way, you can add multiple rows in Excel quite easily.


1. Add Multiple Columns Using Context Menu

In this process, we will use the right key of our mouse to add two columns to our dataset. The columns will be added after the first column or column B of the dataset. The process is given below:

📌 Steps:

  • First of all, select the entire range of cells C5:D5.

  • Now, right-click on your mouse and select the Insert option.

Add Multiple Columns Using Context Menu to Add Multiple Columns in Excel

  • A small dialog box entitled Insert will appear.
  • Now, choose the Entire column option.
  • Click OK.

Add Multiple Columns Using Context Menu to Add Multiple Columns in Excel

  • You will see 2 columns will add before the previously selected columns.

Add Multiple Columns Using Context Menu to Add Multiple Columns in Excel

So, we can say our method worked perfectly.


2. Insert Multiple Columns Utilizing Excel Ribbon

Following this approach, we will use the Excel built-in features to add two columns to our dataset. The columns will be added after column B of the dataset. This is the easiest feature to add columns to a dataset. The steps of this approach are given below:

📌 Steps:

  • First, select the entire range of columns C and D with your mouse.

  • Now, in the Home tab, go to the Cells group. Click on Insert.

Insert Multiple Columns Utilizing Excel Ribbon to Add Multiple Columns in Excel

  • You will see that 2 new columns will be added at the previous position of columns C and D.

Insert Multiple Columns Utilizing Excel Ribbon to Add Multiple Columns in Excel

In the end, we can say that the method worked pretty smoothly.


3. Use of keyboard Shortcut to Add Multiple Columns

Now, we are going to familiarize you with several Excel keyboard shortcuts. These keyboard shortcuts will help you add multiple columns to your dataset within seconds. For all of the cases, we will use the same dataset which we have already used in our previous methods. We will add 2 new columns for every shortcut key and those 2 columns will be added after the column which has the information of employees’ names. The procedure of all cases describes below step by step:


3.1. Use of Ctrl+Shift+‘=’ (Equal Sign)

In the first use of the shortcut keys, we will use ‘Ctrl+Shift+=’  to add two new columns to our dataset.

📌 Steps:

  • Select the entire range of columns B and C with your mouse.

  • Now, press the ‘Ctrl+Shift+=’ keys at the same time on your keyboard.
  • For Mac press Command+Shift+=’ to add new columns.

Use of Ctrl+Shift+‘=’ (Equal Sign) to Add Multiple Columns in Excel

  • You will see that 2 new columns will be added at our desired position.

3.2. Via Alt+H+I+C

Secondly, the ‘Alt’ key will help us to add two new columns to our Excel dataset.

📌 Steps:

  • To add columns, select the range of cells C5:D5.

  • Press the ‘Alt’ button and release it. As a result, some letters will appear in the Toolbar of Excel.

Via Alt+H+I+R to Add Multiple Columns in Excel

  • Now, press H.

Via Alt+H+I+R to Add Multiple Columns in Excel

  • Then, press I.
  • Finally, press C.

Via Alt+H+I+C to Add Multiple Columns in Excel

  • And you will find 2 new columns is added.

Via Alt+H+I+C to Add Multiple Columns in Excel

In this way, you can add multiple columns in Excel quite easily.


3.3. Using Ctrl with ‘+’ Key

Thirdly, we will use the Ctrl with the ‘+’ (Plus) key to add two new columns to the Excel dataset.

📌 Steps:

  • For that, select the entire range of columns B and C.

  • Now, press Ctrl with the ‘+’ (Plus) key at the same time.
  • Two new columns will be added at our desired position.


3.4. Through F4 Key

Finally, we are going to use the ‘F4’ key to add 2 new columns to our spreadsheet. If you are not using a laptop keyboard then you can use this amazing technique.

📌 Steps:

  • In the beginning, select the range of cells C5:D5.

  • Press the ‘F4’ button on your keyboard and you will get 2 new columns before the columns containing salary information.

Through F4 Key to Add Multiple Columns in Excel

In the end, we can say that all of our keyboard shortcuts worked perfectly and we are able to add multiple columns to our dataset.

Read More: How to Convert Multiple Rows to Columns in Excel (9 Ways)


4. Insert Multiple Columns in Different Positions Simultaneously

In this method, we are going to add the columns as 2 non-contiguous columns. To demonstrate this method, we consider the dataset of that 10 employees. At this time, we are going to add the 2 columns after column B and column C. The steps of this process are given as follows:

📌 Steps:

  • First of all, select cell C5 with your mouse.
  • Now, press the ‘Ctrl’ key and select cell D5.

  • After that, in the Home tab, go to Cells group. Then select Insert > Insert Sheet Columns.

Insert Multiple Columns in Different Positions Simultaneously

  • You will find 2 non-contiguous columns inserted after column B and column D.

Insert Multiple Columns in Different Positions Simultaneously

Finally, we can say that our procedure worked effectively and we are able to add 2 non-contiguous columns at our desired location in Excel. So, in this way you can add multiple rows and columns in Excel.

Read More: Excel Macro: Convert Multiple Rows to Columns (3 Examples)


Conclusion

That’s the end of this article. I hope that this content will be helpful for you and you will be able to add multiple rows and columns in Excel. If you have any further queries or recommendations, please share them with us in the comments section below.

Don’t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo