If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
split worksheet
Can you split a worksheet in half vertically, but scroll vertically on
both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It seems by default that if you split horizontally, you get vertical scroll bars. If you split horizontally, you get vertical scroll bars. I want vertical bars w/ a vertical split. OR, some other functinoality that locks in "upper right cells" when I scroll up. Any suggestions? BTW - using Excel 2002. Thank you |
#2
|
|||
|
|||
split worksheet
patrick
Try using 2 windows for the one spreadsheet. Go to Windows/New Window. This will give you two windows on the same sheet. Andy "patrick072040" wrote in message news:axh9b.357412$Oz4.132419@rwcrnsc54... Can you split a worksheet in half vertically, but scroll vertically on both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It seems by default that if you split horizontally, you get vertical scroll bars. If you split horizontally, you get vertical scroll bars. I want vertical bars w/ a vertical split. OR, some other functinoality that locks in "upper right cells" when I scroll up. Any suggestions? BTW - using Excel 2002. Thank you |
#3
|
|||
|
|||
split worksheet
Have you tried using Window, Freeze Panes? First, click on a cell such that
the row just above and the column just to the left of the cell will "freeze." Then select Window, Freeze Panes. MRO "patrick072040" wrote in message news:axh9b.357412$Oz4.132419@rwcrnsc54... Can you split a worksheet in half vertically, but scroll vertically on both?. For example, have cells j1..l8 stay put, when scrolling up cells a1.I100 ? It seems by default that if you split horizontally, you get vertical scroll bars. If you split horizontally, you get vertical scroll bars. I want vertical bars w/ a vertical split. OR, some other functinoality that locks in "upper right cells" when I scroll up. Any suggestions? BTW - using Excel 2002. Thank you |
#4
|
|||
|
|||
split worksheet
It's not possible to have a vertical split where the left half scrolls
vertically and the right does not. The closest you can come to that is to select cell J8 and then Window, Freeze Panes. Alternatively, you can create a second window (Window, New) which you can then size and position for the J1:L8 range. The other window could be used for the big range and the windows will scroll independently. -- Jim Rech Excel MVP |
Thread Tools | |
Display Modes | |
|
|