Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering With Subtotals.
I have a spreadsheet that currently has subtotals in it. I have also applied
auto-filter to the sheet. Whenever I filter for anything, it always pulls the very last subtotal on the sheet. I cannot seem to figure out why it keeps pulling this row. Does anyone know how I can keep this from happening? Thank you! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering With Subtotals.
Can you tell us if the very last line which you mention turns blue when you
autofilter? If it doesn't then it is not included in the filter, so it will always show. To get around this, turn off the filter, then select all the rows, then turn the autofilter back on again. Does that work? -- please reply by thread not email Allllen "pt_lily" wrote: I have a spreadsheet that currently has subtotals in it. I have also applied auto-filter to the sheet. Whenever I filter for anything, it always pulls the very last subtotal on the sheet. I cannot seem to figure out why it keeps pulling this row. Does anyone know how I can keep this from happening? Thank you! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering With Subtotals.
I'd be careful if you're doing this. Data|Filter and Data|Subtotals don't
always work nicely with each other. pt_lily wrote: I have a spreadsheet that currently has subtotals in it. I have also applied auto-filter to the sheet. Whenever I filter for anything, it always pulls the very last subtotal on the sheet. I cannot seem to figure out why it keeps pulling this row. Does anyone know how I can keep this from happening? Thank you! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Presenting Subtotals only | Excel Discussion (Misc queries) | |||
Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
Subtotals copy paste | Excel Worksheet Functions | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Subtotals Problem when Filtering | Excel Discussion (Misc queries) |