4 Easy Ways to Extend a Table in Excel

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

Excel extend table column by typing
Excel extend table column by typing - extended

Step 2: Start typing in the cell below the table’s last row to add a new row

Excel extend table row by typing
Excel extend table row by typing - extended

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 Insert

Excel table right click menu hover Insert

Step 3: Select either Table Columns to the Left / Right for more columns or Table Rows Above / Below for more rows

Excel table right click menu insert row

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

Cell selected inside Excel table

Step 2: Click the Design tab under Table Tools (only appears when a table cell is selected)

Excel Table Tools tab Design option

Step 3: Click the Resize Table button

Excel Resize Table option Design Ribbon

Step 4: Select the first cell of your table and then drag out to the desired new table size

Excel Extend Table Drag Resize Table

Step 5: Click OK

Excel Resize Table OK button

2 thoughts on “4 Easy Ways to Extend a Table in Excel”

  1. My relatives every time say that I am wasting my time here
    at web, except I know I am getting experience every day by reading such pleasant articles or reviews.

    Reply

Leave a Comment