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.


Extend Table in Excel: 4 Ways

In Microsoft Excel, you can make 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 on the right side of the table where it ended. Type the required name just like we did in cell F4.

How to extend table in Excel

  • After entering the required name, 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: How to Rename a Table in Excel


2. Drag the Excel Table to Expand

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: How to Make an Excel Table Expand Automatically


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 on 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 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 extending 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 these Table Tools, you’ll get the Table Design option, where there is an option named 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 Use Sort and Filter with Excel Table


Download Practice Workbook

Download this practice workbook.


Conclusion

We have discussed 4 different ways to extend the table in Excel. It will especially help to extend the table and avoid unnecessary problems while extending the table in Excel. If you have any questions, you can comment below.


Related Articles


<< Go Back to Edit Table | Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo