Amanda,

Only with VBA code (macro or event) used to hide the columns that don't meet your criteria. For
example:

Sub HideX()
Dim myC As Range
For Each myC In Range("B2:H2")
myC.EntireColumn.Hidden = (myC.Value = "X")
Next myC
End Sub

Sub UnHide()
Cells.EntireColumn.Hidden = False
End Sub


HTH,
Bernie
MS Excel MVP


"Amanda L" wrote in message
...
Is there anyway to filter horizontally in Excel, rather than veritcally?