Sideways filtering

R

Randy Harris

I've got worksheet with dates across the top. Is there any practical way to
set up some sort of a filter or something that could hide columns to reveal
just a month or a quarter at a time?
 
T

twox4s

Randy:
You might look at Data...Group and Outline. For instance, if your
first 3 columns of data represent Jan-Mar, then select those 3 columns
and Select DATA...GROUP AND OUTLINE...GROUP. now you can hide or
unhide those months with one mouse click. Hope that helps..... Mark
 
Top