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.
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.
- 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.
- 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.
- 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
- 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.
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.
- 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.
- Finally, a new row will appear at the bottom, as the table will expand in that direction.
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.
- 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.
- 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.
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.
- How to Mirror Table in Excel
- How to Remove Format As Table in Excel
- Excel Table Formatting Problems
- [Fix]: Formulas Not Copying Down in Excel Table
- How to Remove Table Functionality in Excel
- How to Remove Table in Excel
- How to Undo a Table in Excel