How do I freeze a page tab?

[Ken Proj mgr]

I am trying to freeze a page tab (#1) in view while I am scrolling over to
page tab (#99). How can I do this?

 

[David McRitchie]

Hi Ken,
You can't, but you can rearrange your tabs by dragging them around.
It would make a lot more sense to put them into an order where you know
where they are, and if you have more than 15 that would almost certainly
be alphabetical order.
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets

 

[Gord Dibben]

Ken

You could go to Window>New Window then Window>Arrange>Vertical.

Now you can have sheet1 in view and when switching second window to sheet99.


Gord Dibben MS Excel MVP