{"id":331,"date":"2008-04-23T15:43:59","date_gmt":"2008-04-23T20:43:59","guid":{"rendered":"http:\/\/alsplace.aldenbaker.com\/alsplace\/microsoft\/ms-office\/ms-excel\/331\/how-to-subtotal-excel-lists-the-easy-way\/"},"modified":"2008-04-23T15:43:59","modified_gmt":"2008-04-23T20:43:59","slug":"how-to-subtotal-excel-lists-the-easy-way","status":"publish","type":"post","link":"https:\/\/alsplace.info\/?p=331","title":{"rendered":"How to subtotal Excel lists the easy way"},"content":{"rendered":"\n\n

Date<\/strong>: January 25th, 2008<\/p>\n

Author<\/strong>: Susan Harkins<\/p>\n

<\/p>\n

Lists are new in Excel 2003 and they’re great, unless you want to subtotal columns; Excel disables the Subtotal feature for lists. Now, you can keep the list and produce subtotals the hard way. Or you can temporarily convert the list into a conventional range and subtotal the easy way. I always choose the easy way unless I’ve got a good reason to take the hard route.<\/p>\n

Excel 2007 calls lists Tables. If you’re using Excel 2002 or an earlier version, lists aren’t available, but you can still use the easy Subtotal feature. You’ll know lists are in place by the small drop-down controls to the right of each heading cell.<\/p>\n

\"jan2008blog6fig1r.jpg\"<\/p>\n

Before you can subtotal list data, you must convert the list into a conventional range, viagra and premature ejaculation<\/a> as follows:<\/p>\n

\n
    \n
  1. Click anywhere inside the spreadsheet.<\/li>\n
  2. In Excel 2003, choose Lists from the Data menu and select Convert To Range. Excel 2007 users should click the Design tab and click Convert To Range in the Tools group.<\/li>\n
  3. Click OK.<\/li>\n<\/ol><\/div>\n

    Once you have a conventional range, sort the data according to your subtotaling needs. For instance, to subtotal the Total column by Salesperson, you must first sort the data by Salesperson, as follows:<\/p>\n

      \n
    1. \n
      Click in any Salesperson cell.<\/div>\n<\/li>\n
    2. \n
      In Excel 2003 and earlier, click Sort Ascending or Sort Descending, accordingly. Excel 2007 users much select a specific sort by clicking Sort and Filter in the Editing group on the Home tab. Why they made sorting so difficult in 2007, I haven’t a clue.<\/div>\n<\/li>\n<\/ol>\n

      \"jan2008blog6fig2r.jpg\"<\/p>\n

      Now you’re ready to add subtotals, as follows:<\/p>\n

        \n
      1. \n
        Click anywhere inside the spreadsheet.<\/div>\n<\/li>\n
      2. \n
        In Excel 2003, choose Subtotals from the Data menu. Excel 2007 users should click Subtotal in the Outline group on the Data tab. In the Subtotal dialog box, you have a number of choices:<\/div>\n