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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JosiePosie21 - 17 Mar 2006 19:43 GMT

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"?

Reply to this Message

Don Guillett - 17 Mar 2006 19:48 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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"?

Reply to this Message

AndyB - 17 Mar 2006 19:52 GMT

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.

Reply to this Message

Debra Dalgleish - 17 Mar 2006 23:02 GMT

Choose Data>Filter>Show All

> 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"?

Signature

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

Reply to this Message