Aug 03 2019 03:13 AM
Aug 03 2019 03:13 AM
Is there a way to split panes vertically, i.e., to have two independent vertical scroll bars on the same worksheet? Yes, I know you can split on rows and columns, but everything comes with a single vertical scrollbar.
I also know that this can be accomplished by opening and arranging a new window. However, it's cumbersome to do, has to be redone each time the workbook is opened, and requires extra clicks to go back and forth between cells in different windows.
Aug 03 2019 03:48 AM - edited Aug 03 2019 03:57 AM
Yes you can split your window into 4 panes and see four different parts of the same sheet and be able to navigate in each one, although all of them are in the same sheet
To do that:
You can also split on the fly by using the shortcut ALT , W, S (Consecutively not simultaneously)
Hope that helps
Aug 04 2019 03:24 AM
Thanks for your suggestion, Nabil, but I've already tried this. I attempted to say so in my original post, but I wasn't clear enough.
I'd like to divide the pane into left and right sections with a slider for each that would control their vertical motions independently. In other words, I want the left side to stay in position while I move the right side up and down. Although the Excel option you described does have two vertical sliders, they control the top and bottom sections. When you use one or the other, the left and right quadrants slide together.
Aug 04 2019 06:46 AM
That's also possible to scroll vertically on one side but this time we'll use a different functionality:
Hope that Helps
Aug 04 2019 03:12 PM
Thanks again, Nabil, but I've also tried this. I gave reasons in my original post why this isn't a satisfactory solution.
Mar 16 2023 05:40 AM
I guess it's not relevant any more, but I had same problem and now I came across a posible solution. Check out this video https://www.youtube.com/watch?v=-4FmDzfZe20&ab_channel=TrumpExcel
where you are tought to make your on scroll bar. Second half of the video is better (atleast for me). I haven't had "developer" panel up top so I had to enable it in options. For better learning I am sending also the page of the author of the video https://trumpexcel.com/create-a-scroll-bar-in-excel/
I hope this info is heplfull to you or to anyone else