Sunday 15 October 2017

Hints - Microsoft Excel - Freezing Worksheet Tabs

Clair has a workbook that contains over fifty worksheets, one of which is named "Main" and is positioned as the first tab in the workbook. 
Clair  constantly is having to revert back to the "Main" worksheet. In order to display the worksheet he must either click back a tab at a time or scroll all the way to the left of the tabs (by clicking on the control at the far left of the tabs) and then select the "Main" tab. This last method is the easiest, but still is time consuming. 
Clair wonders if there is a way, much like freezing a pane, to freeze a worksheet tab. He would like the "Main" tab to always be visible, and the tabs to its right to scroll.
The short answer is no, there is not a way in Excel to freeze the worksheet tabs. That being said, there are several things you can do to get the results you want.

An option is to remember that you can right-click on the worksheet tab controls at the left of the tabs at the bottom of the Excel window. When you do, you get a list of the first fifteen worksheet names, and you can easily select the "Main" worksheet.
Another option is to set up a very simple macro that always displays the "Main" worksheet:

Assign this macro to a shortcut key.
If you want to always have the "Main" sheet visible in the tabs area, then you must resort to a macro that will continuously reorder the tabs so that "Main" is always visible.

Microsoft Accredited IT Training Provider
Microsoft Certified Training Materials
IT Training Courses delivered by Microsoft Accredited Facilitators
Microsoft MOS Test Centre London

No comments:

Post a Comment