Horizontal Filtering

G

Guest

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
 
B

bepierson

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Draw a horizontal bar and line graph 1
Any way to autofilter at seperate points on the same sheet? 3
Filter for blanks - nonblanks problem 1
Limit filter options in Auto Filter 1
Unable to Insert Columns 5
how to change data from horizontal to be vertical (Excel 2007) 7
Hide rows function 4
2 Horizinotal axes in Excel 2007 8

Top