Twist on Freeze Pane

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I'd like to set up my worksheet such that the top X
number of rows and left-most Y number of columns will
always be visible, but that I'm able to scroll up/down
and left/right with the the rest of the screen. For
example, I want rows 1 through 4 and columns 1 through 3
to always be visible, while all other cells
are 'scrollable'.

Can this be done?

All help is greatly appreciated...
 
Hi Ed,

Select cell D5. Go to Windows>Freeze Panes.

Voila.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
The problem with the simple freeze pane is that when I
scroll, one of the 'frozen' row/column subsets scrolls as
well. I want neither of the frozen row/column subsets to
scroll.
 
Ed,

I see what you mean now, but it ain't going to happen. You are trying to
disassociate parts of a row from the other part, not possible. All columns
in a row will stay together (otherwise they are not part of that row).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Maybe you could do
Window|new window
window|arrange|Horizontal
and adjust the top window to be visible the way you want it.

When you're done, click on the window you don't want and hit ctrl-W.
 
Back
Top