Thread: Remove filters
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 663
Default Remove filters

Hi,

Select the row which contains the arrow, and on the Data menu, point to
Filter, and then click AutoFilter.

Challa Prabhu

"Tom" wrote:

I'm trying to remove the little down arrow indicators in each column of my
sheet that I'm filtering. They won't go away! LOL

Below, I've copied the on-line instructions.

**************************

1. To remove a filter applied to one column in a range or a list, click the
arrow next to the column, and then click All.

2. To remove filters applied to all columns in a range or list, point to
Filter on the Data menu, and then click Show All.

3. To remove the filter arrows from a range or list, point to Filter on the
Data menu, and then click AutoFilter.

********************

I think I need to use number 3, above. But I can't select AutoFilter
because it is grayed out.

Suggestions, please?

--
Tom