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
Completely updated to reflect the many changes in the latest release of Excel, this helpful book presents readers with concise instructions for carrying out common Excel 2007 tasksAn easy-to-navigate design features a two-column layout and is packed with step-by-step directions and illustrations that incorporate the notable changes to Excel 2007Readers can pick the task, find it fast, and get it done quickly, all while gaining a clear understanding of Excel 2007 enhancements, such as a new user interface, improved charting and PivotTable capabilities, and better data exchange with XML
