Freezing worksheet tabs
 

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

Freezing worksheet tabs
 

Colin

Not really.

You might try WindowNew Window and WindowArrangeVertical.

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

On Fri, 16 Jun 2006 22:51:02 +0100, "Colin Foster"
wrote:

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

Freezing worksheet tabs
 

hi,
Not exactly sure what you mean by "as normal" but try this....
on the tool bar click Windownew window
then on the tool bar click windowcompare 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

"Colin Foster" wrote:

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