Converting your Excel data into a table gives you some very useful ways to work more efficiently and effectively. Here are ten reasons you should consider using a table instead of an ordinary data range in Excel.
To create a table, click anywhere inside the data range and click Table in the Tables group on the Insert tab.
1: Easy sorting and filtering
Excel automatically adds filter controls to the header row when you convert a range into a table.
2: Quick formatting
Excel automatically applies a banded row format to new tables.
3: Effortless data entry
You can easily extend a table, making data entry much easier.
4: Automatic nomenclature
When entering formulas, you use cell references and range names. When working with a table, Excel works all that out for you.
5: Quick totals
Want a quick order count? With a table simply click a check-box to add a Totals row.
6: Always visible headers
In a data range, header cells disappear as you scroll, but table headers are always visible — with absolutely no work on your part
7: Formula autofill
When you extend a table to include a new row, it doesn’t just extend the formatting (#3). The table will also copy any formulas.
8: No copy necessary
You can further automate #7 by allowing the table to copy the formula when you enter it.
9: Dynamic charts
If you base a chart on a table, Excel will update the chart automatically as you change and enter new data into the table.
10: One-click select
You select an entire table with a single click.
For details on these visit this excellent Tech Republic article “