At work I deal with several very large worksheets in the same workbook, which basically requires me to use split view to navigate efficiently. The only problem is what split view does to your navigation bar:
excel worksheet bar.PNG
As you can see, the scroll bar for the left pane of split view is jammed into the same space as the worksheet navigation. The scroll bar is now useless because it's tiny and too sensitive. The worksheet navigation is also useless because I can't see more than a few sheets at a time. (I know you can right click on the worksheet navigation arrows to get a pop-up menu, but that's nearly as slow as scrolling through the worksheet bar if I'm constantly navigating between sheets.)
Is there any way to separate the scroll bars from the worksheet tabs so they're not jammed into the same space? I have searched on and off for a couple months now and have never found anything online about this.
Bookmarks