Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
Hello I have a List in which I can filter vertically for a certain entry, but
then I would like to be able to filter horizontally in the way that I just want to see the nonblanks and to hide the blanks, is that possible somehow? thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
Not with anything built in
Regards, Peo Sjoblom "Ed" wrote: Hello I have a List in which I can filter vertically for a certain entry, but then I would like to be able to filter horizontally in the way that I just want to see the nonblanks and to hide the blanks, is that possible somehow? thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
How can I filter horizontally? I just want to do exactly what I do vertically so I can consolidate a large grid with the same headings... I also need to be able to expand quickly and easily. Does anyone have any ideas? -- bepierson ------------------------------------------------------------------------ bepierson's Profile: http://www.excelforum.com/member.php...o&userid=37900 View this thread: http://www.excelforum.com/showthread...hreadid=546043 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
Is this simply not possible? -- bepierson ------------------------------------------------------------------------ bepierson's Profile: http://www.excelforum.com/member.php...o&userid=37900 View this thread: http://www.excelforum.com/showthread...hreadid=546043 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
Not possible AFAIK
Gord Dibben MS Excel MVP On Tue, 22 Aug 2006 16:21:11 -0400, bepierson wrote: Is this simply not possible? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Horizontal Filtering
If you want to do it exactly, you're out of luck.
But you may want to try Data|Group and outline. It may be sufficient. bepierson wrote: How can I filter horizontally? I just want to do exactly what I do vertically so I can consolidate a large grid with the same headings... I also need to be able to expand quickly and easily. Does anyone have any ideas? -- bepierson ------------------------------------------------------------------------ bepierson's Profile: http://www.excelforum.com/member.php...o&userid=37900 View this thread: http://www.excelforum.com/showthread...hreadid=546043 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I enable my mouses Horizontal Scroll in Excel 2007 | Excel Discussion (Misc queries) | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
Insert horizontal line/single cell in Excel? | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |