Resize a table by adding or removing rows and columns

Got it! Here’s how to resize an Excel table by adding or removing rows and columns:

Adding Rows or Columns

To add rows:

• Method 1:
  Click the last cell of the last row in your table and press Tab — Excel will automatically add a new row to the table.
• Method 2:
  Right-click a row below your table, select Insert, then choose Table Rows Above or just insert a row and drag the table range to include it (see resizing below).
• Method 3:
  Click and drag the small resize handle (a little triangle or dot) at the bottom-right corner of the table to extend the table to include new rows.

To add columns:

• Insert a column right next to the table (to the right), and Excel will automatically include it as part of the table.
• Or drag the resize handle to the right to include extra columns.

Removing Rows or Columns

To remove rows:

• Select the row(s) within the table, right-click, and choose Delete Table Rows.
• Or just delete the row normally, and Excel will adjust the table size.

To remove columns:

• Select the column(s) inside the table, right-click, and choose Delete Table Columns.
• Or delete the columns as usual, and the table shrinks accordingly.

Manually resize the table range

• Click anywhere in the table.
• Go to the Table Design tab.
• On the left, click Resize Table.
• In the dialog box, adjust the range manually by typing or selecting a new range with your mouse.
• Click OK.