Excel's List Manager (Figure 13) offers a number of features that make it easier to work with lists.
A list frame surrounds the list so you can see exactly what is included in the list.
A new record row appears at the bottom of the list, so it's easy to add more data and carry formulas forward to new records.
Column headings are kept separate from list contents, so they can never be accidentally sorted into the list's data.
Column headings include a Sort and Filter menu that you can use to rearrange or locate records based on column contents.
The List toolbar offers buttons and menus specifically for working with lists.
There are two ways you can ...