Data Filter Question

  • Thread starter Thread starter john.menken
  • Start date Start date
J

john.menken

When I am trying out different data filter criteria, is there an easy
and fast way to go back to displaying *all* data without clicking on
the drop arrow and selecting All? I am using Excel 2003. Thank you.
 
I've added an icon to my favorite toolbar:

Tools|Customize|Commands tab|data category
Drag the "Show All" (and maybe autofilter) icon to a toolbar.
 
You could set up a macro with shortcut:

How to record a macro:
http://office.microsoft.com/en-us/excel/HA010548371033.aspx


Steps:

1) Turn on Macro recorder
2) In the "Record Macro" box ensure your add a shortcut key in the Shortcut
key box - click in the box and press a key combination:
Say: [Shift]/A
3) Turn off the macro recorder without recording anything
4) [Press Alt]/[F11]
5) Copy the following three lines of code immediately above the 'End Sub'

Dim x
x = Selection.Column
Selection.AutoFilter Field:= x


After setting it up pressing [Shift]/A will set (All) in the column where
you have the cursor (at least, it did in my less-than-comprehensive test).
 
Back
Top