Subtotal show more columns

M

Mandy

When you use subtotal the output is only 2 columns, what you subtotalled on
and your value or whatever you chose to calculate. How can I see other
columns information as well on the subtotal line? I do realize the lines can
be different but how would Excel handle this situation then?
 
S

sally t

Hi Mandy
Using Data - Sub totals should leave all your columns visible and just add
sub totals to the column or columns you specify. Are you changing the Levels
- ie 1,2,3 or hiding any columns? SallyT
 

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

Similar Threads

Getting Text data using the Data - Subtotal feature 1
Conditional SUBTOTAL in XL210 Table 7
Excel subtotals 1
subtotal 2
subtotal titles 1
SUBTOTAL QUERY 5
Subtotals - show all columns? 2
subtotal data from 2 columns into 3rd column 1

Top