I know how to freeze a single point (for rows) and a single point (for
columns) and how to do it at the same time. What I want to be able to do is:

Freeze Rows 1-3
Freeze Rows 381-382

In other words, I want the top of the worksheet to show rows 1-3 at all
times and the bottom of the worksheet to show Rows 381-382 at all times.

Is there a way to do this?

Example:

R1: Title 1 || Title 2 || Title 3
R2: SubT1 || SubT2 || SubT3
R3: SubT4 || SubT5 || SubT6
------------------------------------
R4:
R5:
R6:
------------------------------------
R381: Col1 | Col 2 | Col 3
R382: Total1|Total2|Total3
--
Dawg House Inc.
"We live in it, therefore, we know it!"

Hi

You can use "split window"

Mia

"Dawg House Inc" skrev:

I know how to freeze a single point (for rows) and a single point (for
columns) and how to do it at the same time. What I want to be able to do is:

Freeze Rows 1-3
Freeze Rows 381-382

In other words, I want the top of the worksheet to show rows 1-3 at all
times and the bottom of the worksheet to show Rows 381-382 at all times.

Is there a way to do this?

Example:

R1: Title 1 || Title 2 || Title 3
R2: SubT1 || SubT2 || SubT3
R3: SubT4 || SubT5 || SubT6
------------------------------------
R4:
R5:
R6:
------------------------------------
R381: Col1 | Col 2 | Col 3
R382: Total1|Total2|Total3
--
Dawg House Inc.
"We live in it, therefore, we know it!"

You get one frozen area (or window|split) per window.

Maybe you could use
Window|new Window
Window|arrange|horizontal
(then resize them nicely)

Freeze panes to show rows 1-3 on the top window
and just scroll down to 381-382 on the bottom window
and do all your work on the top window

When you're done, select the window you don't want and hit ctrl-w to close it.


Dawg House Inc wrote:

I know how to freeze a single point (for rows) and a single point (for
columns) and how to do it at the same time. What I want to be able to do is:

Freeze Rows 1-3
Freeze Rows 381-382

In other words, I want the top of the worksheet to show rows 1-3 at all
times and the bottom of the worksheet to show Rows 381-382 at all times.

Is there a way to do this?

Example:

R1: Title 1 || Title 2 || Title 3
R2: SubT1 || SubT2 || SubT3
R3: SubT4 || SubT5 || SubT6
------------------------------------
R4:
R5:
R6:
------------------------------------
R381: Col1 | Col 2 | Col 3
R382: Total1|Total2|Total3
--
Dawg House Inc.
"We live in it, therefore, we know it!"

--

Dave Peterson