×
![]( "Buchcover ISBN 9780470040867")
Excel 2003 Just the Steps For Dummies
von Diane KoersEasy steps for creating spreadsheets you can really use
Simple steps...
... for great results
Use AutoOutline * Choose Data Group and Outline AutoOutline. Figure 11-9illustrates a worksheet with outline headings for both rows andcolumns. Row outline symbols are at the top of the worksheet. * AutoOutline works best if the worksheet has summary formulasthat reference cells in the detail cells. The summary formulas mustbe adjacent to the detail. * To expand the outline, click the Show Detailbuttons to the leftof the rows or above thecolumn headings. (See Figure 11-10.) * To collapse the outline, click the Hide buttonsto the left ofthe rows or above the columnheadings. * To remove the AutoOutline, choose Data Group and outline ClearOutline.
Get ready to * Format cells and data * Build formulas and functions * Save time with Excel tools * Add color graphics toyour spreadsheets * Analyze your data * Create charts and PivotTables
Simple steps...
... for great results
Use AutoOutline * Choose Data Group and Outline AutoOutline. Figure 11-9illustrates a worksheet with outline headings for both rows andcolumns. Row outline symbols are at the top of the worksheet. * AutoOutline works best if the worksheet has summary formulasthat reference cells in the detail cells. The summary formulas mustbe adjacent to the detail. * To expand the outline, click the Show Detailbuttons to the leftof the rows or above thecolumn headings. (See Figure 11-10.) * To collapse the outline, click the Hide buttonsto the left ofthe rows or above the columnheadings. * To remove the AutoOutline, choose Data Group and outline ClearOutline.
Get ready to * Format cells and data * Build formulas and functions * Save time with Excel tools * Add color graphics toyour spreadsheets * Analyze your data * Create charts and PivotTables