Excel 2003 Just the Steps For Dummies

ebook Dummies

By Diane Koers

cover image of Excel 2003 Just the Steps For Dummies

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Library Name Distance
Loading...

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

Excel 2003 Just the Steps For Dummies