Excel: use a list instead of a standard range

Sort and filter lists
AutoFilter drop-down lists [4] are automatically added in the header row of a list when the list is created.
Ensure data integrity
For lists that are not linked to SharePoint lists, you can use the built-in data validation features in Excel.
Easier data entry
using a list will reduce keystrokes, typos and allow more flexibility on the cursor movement and use of forms.
Format list objects
You can format cells in a list the same way that you format cells in a worksheet.
Insert rows
Another action that is common when you work with a list is to add a new row.
This interface element consists of a blank row, displayed directly below the last row of data, with a blue asterisk (*) inside the left-most cell.
Display a total row
To display a total row, click the Toggle Total Row button on the List toolbar.
This total row is displayed below the insert row when the list is active, and shifts up to the row just below the last row of data when the list is not active.
Compatible with lists in Windows SharePoint Services
When you publish a list to a SharePoint site, you are creating a custom SharePoint list.
If you choose to link the list when you publish it, or when you export an existing SharePoint list, you can edit that list offline and synchronize the changes to the SharePoint list at a later time.