Worksheet tabs scroll off screen

R

Ray

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
 
M

Max

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top