New Scroll Bar

[gatesheadthunde]

Hello readers,

Is it possible to add a new scroll bar to a worksheet that will scrol
only a certain part of a sheet?

e.g. If I insert a scroll bar from G10 to G20 and when scrolled
section of the sheet (e.g. G1-G8 down to S1-S8) scrolls whilst leavin
the remaining parts of the sheet unaffected?

Thanks in advanc

 

[Tom Ogilvy]

Not really. You can select G10 and do Windows=>Freeze Panes

and get a similar effect although it will extend all the way down and to the
right. However, this appears to be the opposite of what you described.
(you might be able to reorganize you sheet to take advantage of this
capability)

I did accomplish something similar once. I put my data on a second sheet and
put formulas on the first sheet that used Indirect to address the cells on
the second sheet. I put spin buttons on the first sheet that altered a
number in a cell under the button. The formulas referenced and number and
that adjusted which cells the formulas referred to. This created the
illusion that this section of the sheet was being scrolled.


Another thing that might work is to create a second window into the
worksheet and scroll in the second window. Or you can look into the split
bars on the horizontal and vertical scroll bars.

 

[Andrew]

I don't know of a way to split a specified area as you ask, but you ca
use Split in the Window menu to add a scroll bar. Not sure if this wha
you want though