ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Fixing a sheet tab (https://www.excelbanter.com/setting-up-configuration-excel/130506-fixing-sheet-tab.html)

Brad

Fixing a sheet tab
 
For a workbook comprising many worksheets, enough that some of the sheet
tabs at the bottom are not visible, is there a way to freeze the left-most
sheet tab so that it isn't scrolled out of sight, that is, is always
available to click on?

My thanks in advance for any suggestions here.

Brad



Max

Fixing a sheet tab
 
For an easy "as built" navigation alternative, why not just right-click on
the
vcr-like buttons at the bottom left corner (just to the left of the sheet
tabs). You'd get a pop up sheet listing for easy selection to teleport you
to any desired visible sheet.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brad" wrote in message
...
For a workbook comprising many worksheets, enough that some of the sheet
tabs at the bottom are not visible, is there a way to freeze the left-most
sheet tab so that it isn't scrolled out of sight, that is, is always
available to click on?

My thanks in advance for any suggestions here.

Brad





All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com