When you create a list in Excel, do you automatically convert that list to a formatted table?
If not, you’re missing out on one of Excel’s best features.
Formatted tables are easy to set up, and make it easy to sort, filter, format, and expand your list.
You can refer to the table’s fields in your formulas, and the reference will adjust automatically, if you add or remove data.
Set Up Your Data
There are a few things to check, before you turn your data list into a table. For example:
Add a heading in each data column
Leave blank rows and columns around the list
Don’t leave blank rows or columns within the list
Create the Table
Once the data is set up, select any cell in the list, and click the Table command on the Ribbon’s Insert tab. When the Create Table window opens, check that the range is correct, and check the box for “My table has headers”.
Name Your Table
After you create the table, change its name from the default “Table1” to something meaningful, such as “Orders”. This is especially important if you’re going to have more than one table in the workbook.
Just type over the old name in the Table Name box on the Ribbon’s Design tab.
More Table Tips
For more tips on working with tables, please visit the Excel Tables page on my Contextures website.
Watch the Video
If you haven’t made a formatted table before, you can watch this video, to see the steps.
The video is also on the Excel Tables page on my Contextures website.