Keep first sheet tab "on top"?
 

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

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. |:)

"Jim & Gail" wrote:

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

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.

WindowNew WindowOK

WindowArrangeVertical.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 13:16:29 GMT, "Jim & Gail" wrote:

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