How do I freeze a page tab?
 

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?

How do I freeze a page tab?
 

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...#sortallsheets
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ken Proj mgr" wrote in message ...
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?

How do I freeze a page tab?
 

Ken

You could go to WindowNew Window then WindowArrangeVertical.

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


Gord Dibben MS Excel MVP

On Tue, 7 Mar 2006 05:45:07 -0800, Ken Proj mgr
wrote:

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?