O'Reilly logo

Microsoft Excel X for Mac OS X: Visual QuickStart Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required