A
Amanda L
Is there anyway to filter horizontally in Excel, rather than veritcally?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
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
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
D
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)
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)
M
Max
Amanda L said: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)
---
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
please anyone can help me do this andrews resolution on excel 2010