Horizontal filters?

[Amanda L]

Is there anyway to filter horizontally in Excel, rather than veritcally?

 

[Bernie Deitrick]

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

 

[Dave Peterson]

Maybe you can group the columns.

Select a column(s)
Data|Group and Outline|Group.
(xl2003 menus)

You end up with the outlining symbols at the top. It's not the same as
filtering, though.

Maybe you could define custom views that hide/show the columns you want.
View|Custom Views
(also xl2003 menus)

 

[Max]

Is there anyway to filter horizontally in Excel, rather than vertically?

You could also try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html
There's a d/l link for a sample file on the page
(Horizontal Filter)

---

 

[dusk]

this andrew's link is the answer to the question but anyone knows how to do it? i want it to be done on my file because im using one sheet for my whole file, if i wont be able to do the horizontal filtering i will be obliged to distribute my file to multiple sheets.

please anyone can help me do this andrews resolution on excel 2010

 

[cbbcbb]

Versions of excels from 2003 on have an options button in Sort form - orientation - two choices up to down or left to right. Choose left tot right then pick a row and you're there.