WILEY

KNOWLEDGE FOR GENERATIONS

WILEY - KNOWLEDGE FOR GENERATIONS

United States Change Location

cart.gif CART |  MY ACCOUNT |  CONTACT US |  HELP    
Cover image for product 0764574884
Excel 2003 Just the Steps For Dummies
ISBN: 978-0-7645-7488-7
Paperback
216 pages
April 2006
US $14.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

Other Available Formats: Adobe E-Book
  • Description
  • Table of Contents
  • Author Information
Easy steps for creating spreadsheets you can really use

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