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?

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?

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?