I use the "Show All" from the filter menu & which I have placed on my toolbar
Saintsman

"challa prabhu" wrote:

Hi,

When you use the AutoFilter command, AutoFilter arrows appear to the right
of the column labels in the filtered range.

Scenario:

If you filter more than one cloumn, there are posibility that it becomes
difficult to revert to Unfiltered range from filtered range.

Therefore, I wish if an item by name "Unfilter range" is specified, then the
user view the unfiltered range immediately, rather than manipulating the
filter arrows again.

Challa Prabhu



----------------
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...lic.excel.misc