Forum Discussion
Vertical split panes
- Aug 05, 2019
Hi Ken
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:
- Select any cell (You will be splitting Above and to the Left of the selected cell)
- View Tab >> Click Split >> Enjoy
- To remove >> use the same command
You can also split on the fly by using the shortcut ALT , W, S (Consecutively not simultaneously)
NB:
- In a split window, you can drag the Vertical or Horizontal Divider with your mouse to a different location.
- You Can also scroll each Section Up & Down using the wheel of your mouse. BUT (look at that) you can also scroll Left and Right by PUSHING DOWN the wheel of the mouse and drag !!
- You can remove one (or both ) divider quickly by Double clicking on it.
Hope that helps
Nabil Mourad
- Pedro_YarahuanDec 15, 2022Copper ContributorThanks Nabil, very nice tip
- Ken_StewartAug 04, 2019Copper Contributor
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.