How to Extend Table in Excel (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

To accumulate a dataset, it is a regular practice to use tables in Excel. Creating a table is quite an easy task in Excel and, in addition to that, it is easy to modify the table. When you enter a set of data on a table, you’ll find you need to enter more data that you didn’t enter at first. At that time, you need to extend your table in Excel. This article will give you a total overview of how to extend a table in Excel.


Download Practice Workbook

Download this practice workbook.


4 Ways to Extend Table in Excel

In Microsoft Excel, you can create a Table in various ways. To extend the table in Excel, we found 4 easy ways. Here, we discuss all 4 ways to extend the table in Excel. To explain these ways, we take a dataset with order ID, product, category, and amount. Now, we need to extend this table.

How to extend table in Excel


1. Extend an Excel Table by Typing

First and the easiest way to extend the table in Excel is to start typing in a cell right or to the bottom of it. particularly by doing this, Excel will automatically expand and adjust the table. To do this process, you need to follow the following steps.

  • Firstly you need to start typing at the right side of the table where it finished. Type the required name just like we did in cell ‘F4’.

How to extend table in Excel

  • After entering a required name and press ‘Enter’. Then the value will automatically adjust with the table and at the same time, the table will expand in that direction.

  • Just like the previous one, start typing at the bottom of the table where it finished.

How to extend table in Excel

  • After pressing ‘Enter’, the Excel table will automatically expand in that direction.

Read More: Excel Table Formatting: Problems and Fixes You Need to Know


2. Drag the Excel Table to Expand

Secondly, another easy way to extend the table is to drag the table in the desired direction and it’ll automatically extend the table.

  • When it comes to drag, first you need to look at the ‘small arrow’ at the bottom right of the selected table.

How to extend table in Excel

  • Click this ‘Small arrow’ and drag it to the right side of the table.

  • As you drag it to the right side of the table, it’ll create an expanded table in that direction

How to extend table in Excel

  • Just like the previous one, you can extend the table at the bottom by dragging the ‘Small arrow’ in that direction.

  • When you drag the ‘Small arrow’ in that direction, it’ll create an extended table at the bottom.

Read More: Excel Table Formatting Tips – Change the Look of the Table


Similar Readings


3. Extend Table Using Insert Option

The third approach to extending the table in Excel is by using the ‘Insert’ option in the ribbon.

  • First, you need to select the cell next to where you want to extend your table.

  • Go to the ‘Home’ tab and you’ll find the ‘Insert’ option in the ribbon.

How to extend table in Excel

  • In the ‘Insert’ option you’ll get several like:

Insert Table Row Above: when you select a cell in the table and click on it, a new row above the selected cell will appear.

Insert Table Row Below: It’ll create a new row below the selected cell.

Insert Table Columns to the Left: When you select this, a new column will appear on the left side of the selected cell.

Insert Table Columns to the Right: When you select this, a new column will appear on the right side of the selected cell.

  • Let’s consider that we need to add a new column to the right side of a selected cell. First, go to the insert option and select ‘Insert Table Columns to the Right’.

  • When you click ‘Insert Table Columns to the Right’, the table will automatically extend to the selected right direction.

  • Now you want to extend the table in the bottom direction. Just like the previous one, go to the ‘Insert’ option in the ribbon and select the ‘Insert Table Row Below‘ option.

How to extend table in Excel

  • Finally, a new row will appear at the bottom as well as the table will expand in that direction.

Read More: How to Insert or Delete Rows and Columns from Excel Table


4. Extend Table Using Table Design

Finally, our final approach to extend the table in Excel is by using Table Design. This method provides some more table options to use.

  • First, you need to select any cell in the table that will enable the ‘Table Tools’. In this ‘Table Tools’ you’ll get the ‘Table Design‘ option where there is an option ‘Resize Table’.

How to extend table in Excel

  • Click on ‘Resize Table’, and a new window will appear where you can give your preferred reference.

  • You need to select the first cell of your table and drag it to the desired point.

How to extend table in Excel

  • Also, Place the point in the desired direction and click on ‘OK’. Then it’ll automatically extend the table.

Read More: How to Make Excel Tables Look Good (8 Effective Tips)


Conclusion

We have discussed 4 different ways to extend the table in Excel. Especially it will help to extend the table and avoid unnecessary problems while extending the table in excel. If you have any questions, you can comment below and don’t forget to visit our page Exceldemy for better knowledge about Excel.


Related Articles

Tags:

Durjoy Paul

Durjoy Paul

Hi there! I'm Durjoy. I have completed my graduation from the Bangladesh University of Engineering and Technology. I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo