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.
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’.
- 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.
- After pressing ‘Enter’, the Excel table will automatically expand in that direction.
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.
- 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.
- How to Make Group by Same Interval in Excel Pivot Table (2 Methods)
- How to Illustrate Relative Frequency Distribution in Excel
- Excel Pivot Table Group by Week (3 Suitable Examples)
- How to Make an Amortization Table in Excel (4 Methods)
- How to Remove Format As Table in Excel
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.
- 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 well as the table will expand in that direction.
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’.
- 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.
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.
- How to Sort Multiple Columns of a Table with Excel VBA (2 Methods)
- Applications of Absolute Structured References in Excel Table Formulas
- Excel VBA Code for Each Row in a Table (Add, Overwrite, Delete, etc.)
- Reference Table Column by Name with VBA in Excel (6 Criteria)
- [Fix]: Formulas Not Copying Down in Excel Table (3 Solutions)
- How to Make a Comparison Table in Excel (2 Methods)