Freezing worksheet tabs

C

Colin Foster

Hi All, looking for wisdom,

Is it possible to freeze a worksheet tab so that Sheet 1 is always visible,
whilst 2 - 6 can be scrolled through "as normal"?

Regards
Colin Foster
 
G

Gord Dibben

Colin

Not really.

You might try Window>New Window and Window>Arrange>Vertical.

This will give two windows.

You can leave the first one on sheet1 and scroll through 2-6 in the other
window.


Gord Dibben MS Excel MVP
 
F

FSt1

hi,
Not exactly sure what you mean by "as normal" but try this....
on the tool bar click Window>new window
then on the tool bar click window>compare side by side
this will split the screen and show the same file in two windows. you can
keep sheet one in one window and scroll through the tabs on the other.

regards
FSt1
 
Top