Add or remove Excel table rows and columns

After you create a Microsoft Office Excel table on your worksheet, you can easily add rows and columns. You can quickly add a blank row at the end of the table, include adjacent worksheet rows or worksheet columns in the table, or insert table rows and table columns anywhere that you want.

You can delete rows and columns as needed. You can also quickly remove rows that contain duplicate data from a table.What do you want to do?

Add a blank row at the end of the table

Include a worksheet row or worksheet column in a table

Resize a table

Insert a table row or table column

Delete rows or columns in a table

Remove duplicate rows from a table

Add a blank row at the end of the table

• Select any cell in the last row of the table, and then press ENTER.

  Tip Pressing TAB in the last cell of the last row also adds a blank row at the end of the table. If a totals row is displayed in the table, pressing TAB in the last cell of that row does not add a new row.

Include a worksheet row or worksheet column in a table

• Do one of the following:
  • To include a worksheet row in the table, type a value or text in a cell that is directly below the table.
  • To include a worksheet column in the table, type a value or text in a cell that is directly adjacent to the right of the table.
  • To include worksheet rows or worksheet columns by using the mouse, drag the resize handle at the lower-right corner of the table down to select rows and to the right to select columns.

    

Resize a table

1. Click anywhere in the table.

   Tip This displays the Table Tools, adding the Design tab.

2. On the Design tab, in the Properties group, click Resize Table.

   

3. In the Select the new data range for your table box, type the range that you want to use for the table.

   Tip You can also click the Collapse Dialog button at the right end of the Select the new data range for your table box and then select the range that you want to use for the table on the worksheet. When you finish, click the Collapse Dialog button again to display the entire dialog box.

Tip To resize a table by using the mouse, drag the triangular resize handle at the lower-right corner of the table up, down, to the left, or to the right to select the range that you want to use for the table.

Insert a table row or column

1. Do one of the following:
   • To insert one or more table rows, select one or more table rows above which you want to insert one or more blank table rows.

     Tip If you select the last row, you can also insert a row above or below the selected row.

   • To insert one or more table columns, select one or more table columns to the left of which you want to insert one or more blank table columns.

     Tip If you select the last column, you can also insert a column to the left or to the right of the selected column.

2. On the Home tab, in the Cells group, click the arrow next to Insert.

   

3. Do one of the following:
   • To insert table rows, click Insert Table Rows Above.
   • To insert a table row below the last row, click Insert Table Row Below.
   • To insert table columns, click Insert Table Columns to the Left.
   • To insert a table column to the right of the last column, click Insert Table Column to the Right.

   Tip You can also right-click one or more table rows or table columns, point to Insert on the shortcut menu, and then select what you want to do from the list of options. Or you can right-click one or more cells in a table row or table column, point to Insert, and then click Table Rows or Table Columns.

Delete rows or columns in a table

1. Select one or more table rows or table columns that you want to delete.

   Tip You can also just select one or more cells in the table rows or table columns that you want to delete.

2. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Table Rows or Delete Table Columns.

   

   Tip You can also right-click one or more rows or columns, point to Delete on the shortcut menu, and then click Table Columns or Table Rows. Or you can right-click one or more cells in a table row or table column, point to Delete, and then click Table Rows or Table Columns.

Remove duplicate rows from a table

Just as you can remove duplicates from any selected data in Excel, you can easily remove duplicates from a table.

1. Click anywhere in the table.

   Tip This displays the Table Tools, adding the Design tab.

2. On the Design tab, in the Tools group, click Remove Duplicates.

   

3. In the Remove Duplicates dialog box, under Columns, select the columns that contain duplicates that you want to remove.

   Tip You can also click Unselect All and then select the columns that you want or click Select All to select all of the columns.

Note Duplicates that you remove are deleted from the worksheet. If you inadvertently delete data that you meant to keep, you can click Undo on the Quick Access Toolbar to restore the deleted data. You may also want to use conditional formats to highlight duplicate values before you remove them. For more information, see Add, change, or clear conditional formats.

See also:

• Create or delete an Excel table
• Turn Excel table headers on or off