Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto selection by FILTER
Hello
even when i manually select all data lines above the total line and apply filter (alt+d+f+f XL07) the total line is selected and its giving me headaches while sorting thru the filter and all...Y and any ways to get around this??? Part Descrip Qty Unit Price Ext Price A AAA 1 1 1.00 B BBB 2 2 4.00 C CCC 3 3 9.00 D DDD 4 4 16.00 Total 30.00 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
auto selection by FILTER
As long as you only have one total row (as in, no subtotals) in the column
that has the total you could filter for "does not contain" and filter out the total. Then each time you filter, as long as it's not on that column, your total row won't factor. "walrus" wrote: Hello even when i manually select all data lines above the total line and apply filter (alt+d+f+f XL07) the total line is selected and its giving me headaches while sorting thru the filter and all...Y and any ways to get around this??? Part Descrip Qty Unit Price Ext Price A AAA 1 1 1.00 B BBB 2 2 4.00 C CCC 3 3 9.00 D DDD 4 4 16.00 Total 30.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-filter selection | Excel Discussion (Misc queries) | |||
Expand Selection in Auto filter | Excel Worksheet Functions | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Auto filter multiple selection turn off | Excel Discussion (Misc queries) | |||
# of Records Shown During Auto-Filter Selection | Excel Discussion (Misc queries) |