View Single Post
  #1   Report Post  
Andrew
 
Posts: n/a
Default Advanced Window Split & Freeze Question

Using Excel 97 (SR-2) (upgrade not desired option as
spreadsheet needs to be available to users of all versions
of Excel, ie, I won't know what version they have, so
going with lowest common denominator).

The question is this, by using the Window - Split and
Window - Freeze Pane options I can easily set up the
following...

+-----+---------+
! F ! F !
+-----+---------+
! ! !
! ! !
! H ! H !
! ! !
! ! !
+-----+---------+

F = Frozen
H = scrolls Horizonally

But what I really need to achieve is...

+-----+---------+
! F ! F !
+-----+---------+
! ! !
! ! !
! H ! F !
! ! !
! ! !
+-----+---------+

In other words, only the bottom-left pane is scrollable,
the other three panes don't move. Is this possible? If
so, how is it done?

- Andrew