Excel 2003 Just the Steps for Dummies
By Diane Koers
Series: For Dummies
Language: English
Category: Ebook - Computer/Internet
Categories: Computer/Internet
Uploader:
Uploaded At: 2010-03-11 20:56:57
Easy steps for creating spreadsheets you can really use.
Description
Simple steps...
...for great results
Use AutoOutline
* 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.
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