Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a workbook with about 50 worksheets.
If I scroll along the bottom tabs my first worksheet (which is the menu) disappears off the screen. Is there a way to freeze a worksheet or worksheets so that their tabs are always visible at the bottom of the screen? Thanks |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Don't think so. But if you right-click on the vcr-like tab scroll buttons at
the bottom left of the screen, you would get a pop up menu to easily go to any sheet. And your 1st/leftmost "menu" sheet would appear right at the top of that pop up for easy return. Or, you could try opening a new window (Click Window New Window) Then arrange it to taste (click Window Arrange Tiled (say) OK) with your "menu" sheet "fixed" on the left for reference, with the other window on the right for viewing/scrolling to any other sheet. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Ray" <I ate wrote in message ... I have a workbook with about 50 worksheets. If I scroll along the bottom tabs my first worksheet (which is the menu) disappears off the screen. Is there a way to freeze a worksheet or worksheets so that their tabs are always visible at the bottom of the screen? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scroll a cell to the top left hand corner of the screen | Excel Discussion (Misc queries) | |||
I need to set colums and rows to stay on the screen as I scroll | Excel Worksheet Functions | |||
I need to set colums and rows to stay on the screen as I scroll | Excel Worksheet Functions | |||
Scroll bar Screen tip on Excel 2003 discontinued? | Excel Discussion (Misc queries) | |||
Scroll the screen view with the scroll bar | Excel Discussion (Misc queries) |