software

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

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

--
Don Guillett
SalesAid Software

quot;JosiePosie21quot; gt; wrote in message
...
gt;I am working with Autofilter and I notice that when I filter one column and
gt; then filter another column there is no way to quot;Show Allquot; throughout the
gt; spreadsheet without going to each individual column and selecting it. Is
gt; there a way to quot;Globally Show Allquot;?
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.

quot;JosiePosie21quot; gt; wrote in message
...
gt;I am working with Autofilter and I notice that when I filter one column and
gt; then filter another column there is no way to quot;Show Allquot; throughout the
gt; spreadsheet without going to each individual column and selecting it. Is
gt; there a way to quot;Globally Show Allquot;?
Choose Datagt;Filtergt;Show All

JosiePosie21 wrote:
gt; I am working with Autofilter and I notice that when I filter one column and
gt; then filter another column there is no way to quot;Show Allquot; throughout the
gt; spreadsheet without going to each individual column and selecting it. Is
gt; there a way to quot;Globally Show Allquot;?--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html