View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mia Mia is offline
external usenet poster
 
Posts: 101
Default How to Freeze Multiple Rows/Columns

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!"