How to Add Rows and Columns in Excel (3 Easy Methods)

We often need to add rows and columns in excel. It helps us to reorganize the table or data. We can insert rows and columns to include more information in the data. Therefore, inserting new rows and columns is a necessary task too.

This article illustrates 3 ways how to add rows and columns in excel. The following picture gives a glimpse of idea how the rows and columns look like after insertion.

Rows & Columns Added in Excel


Download Practice Workbook

You can download the practice workbook from the download button below.


3 Ways to Add Rows and Columns in Excel

We have the following dataset to highlight the methods. It contains the results of 12 high school students. Assume that we want to add one or multiple rows below Row 2 and one or multiple columns at the right of Column B in that dataset. The following methods will illustrate how to do that.

Dataset to Illustrate How to Add Rows & Columns in Excel


1. Add Single and Multiple Rows and Columns Using Keyboard Shortcut

You can easily add new rows and columns in excel using the keyboard shortcut.

Keyboard Shortcut: CTRL+

Note: Rows are always added above while Columns are added to the left.

Follow the steps below to be able to do that.

Steps

1. At first, to add a row below row 2, select row 3 by clicking on the row number at the left of the row. (See the arrow in the picture below)

2. After that, hold CTRL & then press the + key. You will see a row added above row 3 & below row 2. Change the formatting according to your requirement using the format icon. Format Same As Above is the default option.

Rows Added in Excel

Add Multiple Rows:

3. Now to add multiple rows above, you need to select the same number of rows first. Let’s select rows 3 to 6 by dragging the mouse over the row numbers.

Selection of Multiple Rows to Add Multiple Rows in Excel

4. Then, press CTRL & the + key together. You will see 4 added rows above row 3.

Multiple Rows Added in Excel

5. Now we are going to add a column at the right of column B. Then, we need to select column C by selecting the column number at the top of the column.

Column Selection to Add New Column in Excel

6. After that, press the CTRL & the + keys together as before. Then, a column will be added to the left as follows.

Column Added in Excel

Add Multiple Columns:

7. Next, select 2 columns instead of one as follows.

Multiple Columns Selection to Add Multiple Columns in Excel

8. Now, press CTRL & + keys together. It will add 2 columns on the left.

Multiple Columns Added in Excel

9. Now you can also select a cell above which you want to add a row or a column at its left. Then if you press the CTRL & + keys together, a small dialog box will popup. You can choose Entire Row to add a row above or Entire Column to add a column to the left of the cell. After that, hit the OK button. Then a new row or a column will be added according to the choice you make.

Cell Selection to Add New Rows or Columns in Excel

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


2. Add Rows and Columns Using Insert Tool

An alternative way to add rows and columns in excel is by using the Insert tool. You need to follow the steps below to see how to do that.

Steps

1. At first, select a cell, in this case, let’s say cell C3. Then, go to the Insert tool from the Home tab. You can choose between inserting rows and columns.

Add New Rows or Columns Using the Insert Tool

2. On the other hand, you will see the alternative options greyed out if you select an entire row or column instead.

3. You can also do so by right-clicking on the selected cells, rows, or columns and then selecting Insert.

Access the Insert Tool by a Righti-click

4. In the case of cell selection, a small Insert dialog box will pop up as shown in the earlier method. In other cases, an equal number of rows or columns will be added accordingly.

Read More: How to Hide Rows and Columns in Excel (10 Ways)


Similar Readings


3. Add Rows and Columns in Excel Table

We can easily add rows and columns to an excel table. To understand how to do that properly, let’s create an excel table using the same dataset. Then follow the steps below.

Excel Table To Practice Adding New Rows & Columns

Steps

1. Suppose you want to add a new row below the table. Then start typing in any of the cells below the last row of the table. For example, type Paul Henry in cell B17.

Add Row in Excel Table by Typing

2. Then hit Enter and you will see an entire row added below the table as follows.

A New Row Added in Excel Table

3. Now you can start typing in any cells right to the last column of the table to add a column to the right of the table. Let’s try typing Remarks in cell F4.

Typing Value to Add New Column in Excel Table

4. Then hit Enter and a new column will be added to the right of the table.

A new Column Added to the Excel Table

5. You can also directly paste data instead of typing to get the same results. Suppose we have copied the following data. Now go back to the original form of the table by pressing CTRL+Z.

Copied Data to Paste to Add New Rows in Excel Table

6. Then paste the copied data into cell B17. The data will be added in new rows in the table. You can add columns in the same way.

New Rows Added to Excel Table by Pasting Data

7. But if the data has more columns than the number of columns in the table, then the table will not expand as shown below.

Problem in Adding New Rows to Excel Table by Pasting Data

8. To fix this problem, click anywhere in the table. Then select Table Design >> Resize Table.

The Resize Table Feature to Add New Rows & Columns in Excel Table

9. After that select the range to which you want to modify your table. Then hit OK.

Selecting New Range for Excel Table to Resize It with Added Rows & Columns

10. Finally your table will be resized with added rows and columns. You can use the Resize Table command to easily add rows and columns to an excel table in one go.

Rows & Columns Added to Excel Table Using the Resize Table Feature

11. Moreover you can use the Insert feature or other earlier methods here too. Just click anywhere in the table. Then it will allow you to add more rows and columns to the table.

Using the Insert Tool to Add Rows & Columns to Excel Table

Read More: Move Row/Column in Excel Without Replacing Existing Data (3 Best Ways)


Things to Remember

  • Always remember that rows are added above and columns are added to the left of the selected field.
  • You need to select the table first to access the Resize Table
  • You must enter or paste data only to the cells adjacent to the table.

Conclusion

Now you know how to add rows and columns in excel in different ways. Interestingly, you can delete rows and columns in similar ways. Using CTRL and keys together will delete the selected rows or columns. You can also use the Delete feature situated just below the Insert feature to delete rows and columns. We will be glad to know if you have any suggestions or further queries. Please share them with us in the comment section below.


Related Articles

Md. Shamim Reza

Md. Shamim Reza

Hello there! This is Md. Shamim Reza. Working as an Excel & VBA Content Developer at ExcelDemy. We try to find simple & easy solutions to the problems that Excel users face every day. Our goal is to gather knowledge, find innovative solutions through them and make those solutions available for everybody. Stay with us & keep learning.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo