Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) |