How to Create Table in Excel

Creating a Table in Microsoft Excel

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.

To Create a Table take the following steps:

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.
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. 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. 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.