Excel® 2013 On Demand

Removing Table Rows and Columns

If you no longer need a row or column in a table, you can quickly remove it using Delete commands on the Home tab. You delete rows and columns in a table the same way you delete rows and columns in a worksheet. As you enter data in a table, sometimes you accidentally enter the same data more than once. Instead of searching for duplicates manually, Excel can search for duplicates and then remove them for you.

Delete Rows or Columns from a Table

Click a cell in the table where you want to delete a row or column.

Click the Home tab.

Click the Delete button arrow, and then click Delete Table Rows or Delete Table ...