The List Manager
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.
Figure 13. Excel's List Manager offers a number of features for working with lists.
There are two ways you can ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
