Freeze Panes

[byrons]

Hi All

I am not sure if there is an answer to this question or not but lets give it a shot...

I have a sheet that has multiple header rows with data beneath. What I want to do is freeze the header row so that I can scroll down the data keeping the header on top, but then when I get to the next header row, I want the freeze to automatically move to keep the next header row frozen (while still being able to see the first header row).

The effect I am looking for is a "stacking" almost, so as I scroll through the data, the relevant header row will be on top.

I look forward to hearing back from someone, and if there is a solution I welcome the input!

Thank you

 

[mathchick]

Hi All

I am not sure if there is an answer to this question or not but lets give it a shot...

I have a sheet that has multiple header rows with data beneath. What I want to do is freeze the header row so that I can scroll down the data keeping the header on top, but then when I get to the next header row, I want the freeze to automatically move to keep the next header row frozen (while still being able to see the first header row).

The effect I am looking for is a "stacking" almost, so as I scroll through the data, the relevant header row will be on top.

I look forward to hearing back from someone, and if there is a solution I welcome the input!

Thank you

There isn't a way to do what you're describing, but depending on how many sections you are you could group the rows so that you can expand and unexpand them so you can choose which sections are visible (and thus just the top row and whatever section you have expanded would be showing).
~Mathchick

 

[byrons]

Thank you Mathchick!

The grouping function will do the job.

 

[mathchick]

Thank you Mathchick!

The grouping function will do the job.

You're welcome! Thanks for the feedback!
~Mathchick