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.