4 Easy Ways to Extend a Table in Excel

When working with raw data, there’s few better tools out there than Microsoft Excel. From simple formulas to complex pivot tables, Excel makes analyzing data much easier. Many of this starts with a simple table though, and knowing how to work with them is key to visually presenting your data.

Tables in excel are easy to create and can even be easily modified when new data is available. You’ll likely find yourself needing to resize or extend a table in Excel more often than not. In this article, we’ll show you 4 different ways to do just that.

4 Methods to Extend a Table in Excel

Extend Table by Typing

The easiest way to extend a table in Excel is to simply start typing in a cell below or to the right of it. Excel will automatically create a new row or column to fit the new data.

  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
  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

Extend 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.

  1. Locate the small blue arrow at the bottom right hand corner of your table.
    Excel extend table arrow highlighted
  2. Click and drag the arrow down for more rows, or to the right for more columns.
    Excel extend table rows
    Excel extend table columns

Resize a Table via Right Click

You can also right click inside the table and add a single row or column at a time.

  1. Right click anywhere inside the table.
  2. Hover over Insert.
    Excel table right click menu hover Insert
  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

Resize a Table with 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.

  1. Click anywhere inside your table so that the Table Tools tab appears.
    Cell selected inside Excel table
  2. Click the Design tab under Table Tools.
    Excel Table Tools tab Design option
  3. Select Resize Table at the far left of the ribbon.
    Excel Resize Table option Design Ribbon
  4. Select the first cell of your table and then drag out to the desired new table size.
    Excel Extend Table Drag Resize Table
  5. Click OK.
    Excel Resize Table OK button

Extending a Table in Excel for the Web

The above methods should work in Excel for the web, but you can also resize a table manually in the Table Design tab.

  1. Click anywhere inside the table so that the Table Design tab appears.
  2. Click the Table Design tab and select Resize Table at the far left of the ribbon.
    Excel Web Resize Table in Table Design Ribbon
  3. Type in a new range of cells for your table and click Ok.
    Excel Web Resize Cell Range and Ok Button in Resize Table Box

3 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