ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sideways filtering (https://www.excelbanter.com/excel-discussion-misc-queries/50881-sideways-filtering.html)

Randy Harris

Sideways filtering
 
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?


[email protected]

Sideways filtering
 
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



All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com