Sargum,

Copy the code below, then right-click the sheet tab and select "View Code". Paste the code into the
window that appears.

HTH,
Bernie
MS Excel MVP


Public myCol As Integer

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If myCol = 0 Then myCol = Target.Cells(1).Column
If myCol < Target.Cells(1).Column Then
If ActiveSheet.FilterMode Then ActiveSheet.ShowAllData
myCol = Target.Cells(1).Column
End If

End Sub

wrote in message ps.com...
Hello,

I have an Excel 2003 file with 8 columns that one could filter on.
The AutoFilter function is set to ON. I have found that the users do
not always remember to click on (All) in the filter drop down menu
before moving to the next column and filtering...they end up with
narrowing down on their filter choices when all they wanted to do was
filter exclusively on the next column criteria.

With this dataset, there will never be a need to narrow down...Hence,
how do I make it so that if one moves to another column to filter, it
automatically sets everything back to (All)? There are way too many
users to train to select (All) every time they move to a different
column to filter on a different subject so a solution here would be of
great help!

Sargum