Data/Subtotal


G

Guest

Excel Help states that I should be able to use the Subtotal command under the
data menu with an Excel List (created with the Create List command under the
Data menu). When I create the list and then attempt to use subtotal, the
option is grayed until I convert the list back to a standard range.....Can
anyone tell me what I am doing wrong. Help text is below:

Microsoft Excel can automatically calculate subtotal and grand total values
in a list (list: A series of rows that contains related data or a series of
rows that you designate to function as a datasheet by using the Create List
command.). When you insert automatic subtotals, Excel outlines the list so
that you can display and hide the detail rows for each subtotal.
 
Ad

Advertisements

G

Guest

Don't worry about the Create List thing. Make sure that your data is sorted
into groups to be subtotaled and then just use Data -> Subtotal... You can
also use pivot tables to do approximately the same thing. I prefer pivot
tables but that might just be more of a personal bias...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top