Prev: Computed value returning#VALUE
Next: paper size options in page setup
From: stew on 23 Mar 2010 12:57
I am not really sure what to call this or if it's even possible, can you
freeze a row, then while scrolling down have the frozen row be replaced by
another row that will be frozen and so on?

For example:
I freeze row 5 which has column headers. As I scroll down the spreadsheet I
reach row 100, which has different column headers. Can the headers be
replaced so now row 100 is frozen? But at the same time once I scroll back
up above row 100 it would resort back to the headers in row 5....

From: Bob I on 23 Mar 2010 13:33
Put the disparate data on sheet2

stew wrote:

> I am not really sure what to call this or if it's even possible, can you
> freeze a row, then while scrolling down have the frozen row be replaced by
> another row that will be frozen and so on?
>
> For example:
> I freeze row 5 which has column headers. As I scroll down the spreadsheet I
> reach row 100, which has different column headers. Can the headers be
> replaced so now row 100 is frozen? But at the same time once I scroll back
> up above row 100 it would resort back to the headers in row 5....
>

From: Gord Dibben on 23 Mar 2010 13:35
No

I would add a new window and arrange them horizontally

Each window would have the top row frozen.

Involves switching windows but does the trick.


Gord Dibben MS Excel MVP

On Tue, 23 Mar 2010 09:57:01 -0700, stew <stew(a)discussions.microsoft.com>
wrote:

>I am not really sure what to call this or if it's even possible, can you
>freeze a row, then while scrolling down have the frozen row be replaced by
>another row that will be frozen and so on?
>
>For example:
>I freeze row 5 which has column headers. As I scroll down the spreadsheet I
>reach row 100, which has different column headers. Can the headers be
>replaced so now row 100 is frozen? But at the same time once I scroll back
>up above row 100 it would resort back to the headers in row 5....

 | 
Pages: 1
Prev: Computed value returning#VALUE
Next: paper size options in page setup