LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"