When you create a table in Microsoft Office Excel, you can manage and analyze the data in that table independently of data outside of the table. For example, you can filter table columns, add a row for totals, apply table formatting, and publish a table to a server that is running Microsoft Windows SharePoint Services 3.0.

When you don't need a table anymore, you can remove it by converting it back to a range or you can delete it.What do you want to do?

Create a table

  1. On a worksheet, select the range of empty cells or data that you want to make into a table.
  2. On the Insert tab, in the Tables group, click Table.

    excel ribbon image

  3. If the selected range contains data that you want to display as table headers, select the My table has headers check box.

    Table headers display default names that you can change if you don't select the My table has headers check box.

Note After you create a table, the Table Tools become available, and a Design tab is displayed. You can use the tools on the Design tab to customize or edit the table.

Convert a table to a range of data

  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 Convert to Range.

    excel ribbon image

    Tip You can also right-click the table, point to Table, and then click Convert to Range.

Tip Immediately after creating a table, you can also click Undo button image on the Quick Access Toolbar to convert that table back to a range.

Delete a table

  1. On a worksheet, select a table.
  2. Press DELETE.

Tip You can also click Undo button image on the Quick Access Toolbar to delete a table that you just created.



See also: