Data Filter Question

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

 

[Dave Peterson]

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.

 

[AltaEgo]

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

 

[Bob Umlas]

Alt/DFS