Excel tables are pretty dynamic and can easily have their number of rows and columns increased or decreased. Below are some of the ways to extend a table in excel sorted by the easiest options first.
How to Extend a Table by Typing
The easiest method is to simply start typing. Excel will automatically create a new row or column to fit the new data.
Step 1: Start typing in the cell to the right of the table’s last column to add a new column
Step 2: Start typing in the cell below the table’s last row to add a new row
How to Resize a Table by Dragging
Another way to extend a table in excel is to simply drag the small arrow at the bottom right of the table. The table will resize to fit the cells you drag over.
Step 1: Locate the small blue arrow at the bottom right hand corner of your table.
Step 2: Click and drag the arrow down for more rows, or to the right for more columns.
How to Extend a Table via Right Click
You can also right click inside the table and add a single row or column at a time.
Step 1: Right click anywhere inside the table
Step 2: Hover over
Step 3: Select either
Table Columns to the Left /
Right for more columns or
Table Rows Above /
Below for more rows
How to Resize a Table via Table Tools
The final approach is probably the longest method, but does provide some additional table options if you need them. The
Table Tools tab allows you to resize a table via the
Resize Table button.
Step 1: Click anywhere inside your table
Step 2: Click the
Design tab under
Table Tools (only appears when a table cell is selected)
Step 3: Click the
Resize Table button
Step 4: Select the first cell of your table and then drag out to the desired new table size
Step 5: Click