Keep first sheet tab "on top"?

[Jim & Gail]

I have a workbook with 41 sheets. Essentially all of the data entry is done
in the first sheet, named 'Report'. Is it possible to keep my Report sheet
"on top," so to speak, while I scroll left and right through the other 40
sheets?

Thanks,
Jim

 

[Guest]

If you use the scroll buttons to the left of the tabs, the active sheet
remains the active sheet. Focus only shifts to another sheet if you click
it's tab or Ctrl+PgDn. |:>)

 

[Gord Dibben]

Jim

How about two windows?

One with the Report sheet in view and the other you can scroll through and
select another sheet to view.

Window>New Window>OK

Window>Arrange>Vertical.


Gord Dibben Excel MVP