Choose DataFilter Show All

If you use this feature frequently, you can add the Show All button to
one of your toolbars:

Choose ToolsCustomize
Select the Commands tab
Select the Data category
In the list of Commands, find Show All, and drag it to one of your toolbars.
Close the Customize dialog box.

jenn wrote:
is there a way to reset the auto filter so that the filter is still ON but
nothing is filtered out? Normally I go to DataFilterAuto filter to turn it
off and then go turn it on again


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html