Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
B B is offline
external usenet poster
 
Posts: 17
Default excel should let me unfilter all columns with one click

Don't you hate it when you need to copy and paste, or even create a new
filtered search but you've got a bunch of active filters on already and you
have to scroll thru all your columns, unfiltering them one by one till it
reads "ready" again?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default excel should let me unfilter all columns with one click

Hi B,

Have you tried:

Data | Filter Show All


---
Regards,
Norman



"B" wrote in message
...
Don't you hate it when you need to copy and paste, or even create a new
filtered search but you've got a bunch of active filters on already and
you
have to scroll thru all your columns, unfiltering them one by one till it
reads "ready" again?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,886
Default excel should let me unfilter all columns with one click

Hi

Right Click on your Toolbar area, and choose CustomiseCommandsData and
whilst holding your left mouse button down, drag Show All to any
position on one of your Toolbars.

Now a single click on this new button will remove all filters for you.

--
Regards

Roger Govier


"B" wrote in message
...
Don't you hate it when you need to copy and paste, or even create a
new
filtered search but you've got a bunch of active filters on already
and you
have to scroll thru all your columns, unfiltering them one by one till
it
reads "ready" again?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I
Agree" button in the message pane. If you do not see the button,
follow this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming



Reply
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
unfilter peyman Excel Discussion (Misc queries) 2 October 26th 07 05:45 PM
cannot RIGHT click on rows or columns in excel [email protected] Excel Discussion (Misc queries) 0 October 16th 06 05:46 PM
Code to unfilter one field only scrabtree23[_3_] Excel Programming 2 November 19th 05 04:03 PM
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Unfilter JohnUK Excel Programming 2 June 18th 04 04:33 PM


All times are GMT +1. The time now is 10:42 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"