Vertical split panes
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 v...
Forum Discussion
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
Thanks Nabil, very nice tip