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.

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...
--
HTH...

Jim Thomlinson


"sweetmans" wrote:

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.

The reason I wanted to use the data as a list is because the Data Validation
options work better when used within the list (they repeat themselves with
each new record) but they do not with just a standard range......It just
seems like Excel is inconsistent when attemting to use the options under the
data menu......maybe thats just the way it is.....

"Jim Thomlinson" wrote:

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...
--
HTH...

Jim Thomlinson


"sweetmans" wrote:

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.