Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |