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

J

JosiePosie21

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

Guest

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.
 
D

Debra Dalgleish

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"?
Click to expand...
 
Top