Resize a table, column, or row

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns.

You can use the Resize command in Excel to add rows and columns to a table:

Click anywhere in the table, and the Table Design tab appears.
Select Table Design > Resize Table.
Select the entire range of cells you want your table to include, starting with the upper-most cell.

In the example shown below, the original table covers the range A1:C5. After resizing to add two columns and three rows, the table will cover the range A1:E8.