Learn Excel 2011 for Mac

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.

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