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 ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
