After you create a list, you can sort the entries, add new entries, and display totals. You can insert rows anywhere in a list or add rows at the bottom of the list. The last row of the list is a blank row with a blue asterisk (*) inside the left-most cell . You can type a new entry in the list directly into the last row. When the list is inactive, the asterisk does not appear in the list, and the list border shifts up to the bottom of the last row of data. If you no longer need the data in list form, you can convert the list back to normal Excel data.
Insert a Row in a List
Convert a List to a Range