Wiley Excel 2003 Just the Steps For Dummies 216pages software manual

Excel 2003 Just the Steps For Dummies <b>Easy steps for creating spreadsheets you can really use</b>
Simple steps...

...for great results

<b>Use AutoOutline</b>
- Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.
- AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.
- To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)
- To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.
- To remove the AutoOutline, choose Data Group and outline Clear Outline.

<b>Get ready to</b>

- 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