Lateral Filters, Excell 10'

[A.Berry]

Hey guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
First time threader, long time listener.<o></o>
I am have trouble figuring out whether or not you can filter in the lateral direction. <o></o>
<o></o>
I have categorical data ranging from cells B5:B12 (i.e: manufacturing roofs, walls, floors ect.), and then from column C onwards i have dates set up like a long stringed calendar. <o></o>
<o></o>
My question is, is it possible to create a filter or something to shorten the span of my calendar section to the current month or two in advance and hide the months that have past?

Thank you,


Kind regards

 

[shg]

Welcome to the board.

You can't filter horizontally, but you can hide columns manually.

 

[A.Berry]

Yes ok,

I thought that may have been the only way,

Thanks for the help, catch you next time.

ciao

 

[shg]

You're welcome. In that and many other ways, Excel is very row-centric.