Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default Remove filters

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy with filters but not copy the filters in the middle? ztalove Excel Discussion (Misc queries) 0 November 1st 06 04:53 PM
Using Filters Annie Excel Discussion (Misc queries) 2 September 29th 06 03:08 PM
Filters, Subtotal & Intacted Results after the filters' Removal kasiopi Excel Discussion (Misc queries) 5 February 24th 06 12:18 PM
Filters Jerry Excel Discussion (Misc queries) 1 February 3rd 06 12:18 AM
Filters Q John Excel Discussion (Misc queries) 4 November 12th 05 10:37 PM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"