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 Data>Filter>Auto filter to turn it
off and then go turn it on again
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 Data>Filter>Auto filter to turn it
off and then go turn it on again
Go to the top of the "filtered column(s)" and choose the "All"
selection........
Vaya con Dios,
Chuck, CABGx3
"jenn" <[email protected]> wrote in message
news:[email protected]...
> 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 Data>Filter>Auto filter to turn
it
> off and then go turn it on again
yes... is there a way to change all the filter columns to ALL... rather than
turn the auto filter off and back on... or changing the filterd columns back
to ALL.
"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 Data>Filter>Auto filter to turn it
> off and then go turn it on again
Choose Data>Filter> Show All
If you use this feature frequently, you can add the Show All button to
one of your toolbars:
Choose Tools>Customize
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 Data>Filter>Auto 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks