Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autofilter indication when being used
I have about 15 columns in my spreadsheet and I'm using the Autofilter quite
heavily with the work I'm doing. The problem is I can't always tell which fields/columns the filter is applied to without manually going through each one to see what, if anything, is selected. Is there a way for the selected value to be displayed above the Autofilter line or else for the column to change color or become boldfaced so I can quickly tell which fields are being filtered? I am running Excel 2000 by the way. Thanks for your help. |
#2
|
|||
|
|||
Hi Cheese,
See this recent post from Debra Dalgeish which includes a UDF from Tom Ogilvy which may answer your requirement. http://tinyurl.com/ex6vp --- Regards, Norman "Cheese" wrote in message ... I have about 15 columns in my spreadsheet and I'm using the Autofilter quite heavily with the work I'm doing. The problem is I can't always tell which fields/columns the filter is applied to without manually going through each one to see what, if anything, is selected. Is there a way for the selected value to be displayed above the Autofilter line or else for the column to change color or become boldfaced so I can quickly tell which fields are being filtered? I am running Excel 2000 by the way. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFilter toggling in VBA (How to use correctly) | Excel Discussion (Misc queries) | |||
Improve autofilter combine conditionals with filter criteria | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |