Instead of entering the records of a data list directly in the table, you can use Excel's data form to make the entries. The only problem with using the data form is that the command to display the form in a worksheet with a data list is not part of the Ribbon commands.
Creating a new data list in a worksheet is much like creating a worksheet table except that it has only column headings and no row headings.
You need to use more than one field in sorting when the first field you use contains duplicate values and you want a say in how the records with duplicates are arranged. (If you don't specify another field to sort on, Excel just puts the records in the order in which you entered them.)