O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Creating a Collapsible Worksheet by Outlining It

Worksheets that contain many columns or rows of data can become hard to navigate even if you freeze the headings on screen the way you learned in Chapter 1. To make navigation easier, you can use Excel's outlining feature to create a collapsible worksheet, and then expand only those sections you need to see at any particular time. Figure 3–17 shows a worksheet containing an outline with some rows and columns expanded and others collapsed.

images

Figure 3–17. Use Excel's outline features to create a worksheet that you can collapse and expand to show only the sections you need.

Outlining works best for ...

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