Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there anyway to filter horizontally in Excel, rather than veritcally?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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) Amanda L wrote: Is there anyway to filter horizontally in Excel, rather than veritcally? -- Dave Peterson |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
"Amanda L" wrote:
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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filters | Excel Discussion (Misc queries) | |||
How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Filters | Excel Discussion (Misc queries) | |||
Using Filters | Excel Discussion (Misc queries) |