O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Working with List Objects

Working with List Objects

If you select any cell within a list and press Ctrl+L (or choose Data, List, Create List), Excel presents a dialog box similar to the following:

Working with List Objects

The dialog box (and the menu command that summons it) is somewhat misleading. You already have a list (even if all you have created so far is a header row), so Excel is not about to create one for you. What it is proposing to do is turn your list into a list object, thereby conferring upon it certain properties that it didn't have before. Those properties are as follows:

  • The list object ...

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