How do you globally display "All" in an Autofilter?
 

I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?

How do you globally display "All" in an Autofilter?
 

try
Sub showall()
On Error GoTo away
ActiveSheet.ShowAllData
away:
End Sub

--
Don Guillett
SalesAid Software

"JosiePosie21" wrote in message
...
I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?

How do you globally display "All" in an Autofilter?
 

Hi

Go to View/Toolbars/Customise. Select Data in the left window and you can
then drag 'Show All' onto your toolbar. This will clear all filters. There's
also a useful Autofilter there, which means you can select a cell and the
autofilter will switch on (if off) and autofilter to that value.

Hope this hlpes.
Andy.

"JosiePosie21" wrote in message
...
I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?

How do you globally display "All" in an Autofilter?
 

Choose DataFilterShow All

JosiePosie21 wrote:
I am working with Autofilter and I notice that when I filter one column and
then filter another column there is no way to "Show All" throughout the
spreadsheet without going to each individual column and selecting it. Is
there a way to "Globally Show All"?


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