Forum Discussion
Locking a Sheet in Place?
If i have a workbook with more sheets than able to be displayed without scrolling, is there a way to lock or freeze a sheet in place so that when scrolling the other sheets/tabs change as expected with the exception of the one i want to always be the first on the left?
In the above example, if i added a new sheet or clicked to see the Dec 24 sheet / tab, the "Change to Backdrop" would still be visible to select and Dec 11 would out of view etc.
No matter how this question is searched, the results are always about freezing rows, columns or panes within a sheet and not what i am looking for.
Afraid that's not possible. Perhaps the goal is not to keep "Change to Backdrop" always visible, but quickly select it without scrolling. Some workaround could be right click menu on arrow or Navigation pane.
Afraid that's not possible. Perhaps the goal is not to keep "Change to Backdrop" always visible, but quickly select it without scrolling. Some workaround could be right click menu on arrow or Navigation pane.
Thank you for your reply. I did manage to locate a response relating to using a macro to get back the main sheet in a multi sheet workbook which is somewhat helpful. I am surprised that this hasn't been an added feature for Excel as there have been a few people looking to do the same thing.
I appreciate your response :-)
