Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

Dummies.com
  • Print
  • Share
Excel 2003 Just the Steps For Dummies (0470040866) cover image

Excel 2003 Just the Steps For Dummies

ISBN: 978-0-470-04086-7
E-book
209 pages
June 2006
US $9.99 Purchase This E-book

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

How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.
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
  • Print
  • Share