ENGLISH

Excel 2003 Just the Steps For Dummies (For Dummies (Computer Tech))

By Diane Koers

Book information

Year
2006
ISBN
0764574884, 9780764574887, 9780470040867
LCC
HF5548.4.M523 K64 2006
Open Library ID
OL17896839M
Language
english
Format
PDF
Filesize
10 MB (10266506 bytes)
Edition
1
Pages
216\218
Topic
Computers
Time added
2011-06-04 13:46:07

Description

Easy steps for creating spreadsheets you can really useSimple steps......for great resultsUse AutoOutlineChoose 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 toFormat cells and dataBuild formulas and functionsSave time with Excel toolsAdd color graphics toyour spreadsheetsAnalyze your dataCreate charts and PivotTables

Similar books