Microsoft Office Tutorials and References
In Depth Information
Working with Excel Tables
Converting a range to an Excel table
To convert a range of data to an Excel table, follow these steps:
1. Highlight the range of cells that contain the data you want to include in your Excel table.
2. On the Insert tab of the Ribbon, click the Table button.
The Create Table dialog box opens, as shown in Figure 11-19.
3. In the Create Table dialog box, verify the range for the table and specify whether the first row
of the selected range is a Header row.
4. Click OK.
Figure 11-19: Converting a range of data to an Excel table.
After the conversion takes place, notice a few small changes. Excel put drop-down lists in each
Header row, the rows in your table now have alternate shading, and any header that didn’t have a
value has been named by Excel.
You can use Excel tables as the source for charts, pivot tables, list boxes, or anything else for which
you normally use a data range. In Figure 11-20, a bar chart has been linked to the Excel table.
Figure 11-20: Excel tables can be used as source data for charts, pivot tables, named ranges, and so on.