Page 265 - Excel 2013 All-in-One For Dummies

Reorganizing the Workbook 247
Keep in mind that restoring an outline that you’ve deleted is not one of the commands that you can undo (Ctrl+Z). If you delete an outline by mistake, you must re-create it all over again. For this reason, most often you’ll want to expand all the outline levels (by clicking the lowest number column and row level button) and then hide all the outline symbols by pressing Ctrl+8 rather than permanently remove the outline. Note that if you press Ctrl+8 when your spreadsheet table isn’t yet outlined, Excel displays an alert dialog box indicating that it can’t show the outline symbols because no outline exists. This alert also asks you whether you want to create an outline. To go ahead and outline the spreadsheet, click OK or press Enter. To remove the alert dialog box without creating an outline, click Cancel.
Creating different custom views of the outline
After you’ve created an outline for your worksheet table, you can create custom views that display the table in various levels of detail. Then, instead of having to display the outline symbols and manually click the Show Detail and Hide Detail buttons or the appropriate row level buttons and/or column level buttons to view a particular level of detail, you simply select the appro- priate outline view in the Custom Views dialog box (View➪Custom Views or Alt+WCV).
When creating custom views of outlined worksheet data, be sure that you leave the Hidden Rows, Columns, and Filter Settings check box selected in the Include in View section of the Add View dialog box. (See Book II, Chapter 3 for details on creating and using custom views in a worksheet.)
Reorganizing the Workbook
Any new workbook that you open already comes with a single blank work- sheet. Although most of the spreadsheets you create and work with may never wander beyond the confines of this one worksheet, you do need to know how to organize your spreadsheet information three-dimensionally for those rare occasions when spreading all the information out in one humon- gous worksheet is not practical. However, the normal, everyday problems related to keeping on top of the information in a single worksheet can easily go off the scale when you begin to use multiple worksheets in a workbook. For this reason, you need to be sure that you are fully versed in the basics of using more than one worksheet in a workbook.
To move between the sheets in a workbook, you can click the sheet tab for that worksheet or press Ctrl+PgDn (next sheet) or Ctrl+PgUp (preceding sheet) until the sheet is selected. If the sheet tab for the worksheet you want is not displayed on the scroll bar at the bottom of the document window, use the tab scrolling buttons (the buttons with the left- and right-pointing triangles) to bring it into view.
Book II Chapter 4
Managing Worksheets