Excel 2003 Just the Steps for Dummies

id: 35198 not VIP Open in MaM

By Diane Koers

Series: For Dummies

Language: English

Category: Ebook - Computer/Internet

Categories: Computer/Internet

Size: 9.8 MiB pdf Files: 1

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

Other Torrents