Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default Worksheet tabs scroll off screen

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   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Worksheet tabs scroll off screen

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll a cell to the top left hand corner of the screen Daveh Excel Discussion (Misc queries) 2 August 30th 06 05:17 PM
I need to set colums and rows to stay on the screen as I scroll ksholars Excel Worksheet Functions 0 August 19th 06 08:50 PM
I need to set colums and rows to stay on the screen as I scroll Toppers Excel Worksheet Functions 0 August 19th 06 08:48 PM
Scroll bar Screen tip on Excel 2003 discontinued? pennyb Excel Discussion (Misc queries) 1 December 15th 05 11:59 AM
Scroll the screen view with the scroll bar avbs Excel Discussion (Misc queries) 1 June 25th 05 04:43 PM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"