• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Reordering and Summarizing Data > Organizing Data into Levels

Organizing Data into Levels

After you have sorted the rows in an Excel worksheet or entered the data in such a way that it doesn’t need to be sorted, you can have Excel calculate subtotals, or totals for a portion of the data. In a worksheet with sales data for three different product categories, for example, you can sort the products by category, select all of the cells that contain data, and then open the Subtotal dialog box.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint