SOLVED
Home

Vertical split panes

%3CLINGO-SUB%20id%3D%22lingo-sub-786700%22%20slang%3D%22en-US%22%3EVertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786700%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20split%20panes%20vertically%2C%20i.e.%2C%20to%20have%20two%20independent%20vertical%20scroll%20bars%20on%20the%20same%20worksheet%3F%20Yes%2C%20I%20know%20you%20can%20split%20on%20rows%20and%20columns%2C%20but%20everything%20comes%20with%20a%20single%20vertical%20scrollbar.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20know%20that%20this%20can%20be%20accomplished%20by%20opening%20and%20arranging%20a%20new%20window.%20However%2C%20it's%20cumbersome%20to%20do%2C%20has%20to%20be%20redone%20each%20time%20the%20workbook%20is%20opened%2C%20and%20requires%20extra%20clicks%20to%20go%20back%20and%20forth%20between%20cells%20in%20different%20windows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786712%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786712%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385141%22%20target%3D%22_blank%22%3E%40Ken_Stewart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Ken%3C%2FP%3E%3CP%3EYes%20you%20can%20split%20your%20window%20into%204%20panes%20and%20see%20four%20different%20parts%20of%20the%20same%20sheet%20and%20be%20able%20to%20navigate%20in%20each%20one%2C%20although%20all%20of%20them%20are%20in%20the%20same%20sheet%3C%2FP%3E%3CP%3ETo%20do%20that%3A%3C%2FP%3E%3COL%3E%3CLI%3ESelect%20any%20cell%20(You%20will%20be%20splitting%20Above%20and%20to%20the%20Left%20of%20the%20selected%20cell)%3C%2FLI%3E%3CLI%3EView%20Tab%20%26gt%3B%26gt%3B%20Click%20Split%20%26gt%3B%26gt%3B%20Enjoy%3C%2FLI%3E%3CLI%3ETo%20remove%20%26gt%3B%26gt%3B%20use%20the%20same%20command%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20split%20on%20the%20fly%20by%20using%20the%20shortcut%20%3CFONT%20face%3D%22book%20antiqua%2Cpalatino%22%20color%3D%22%23FF0000%22%3E%3CSTRONG%3EALT%20%2C%20W%2C%20S%3C%2FSTRONG%3E%3C%2FFONT%3E%26nbsp%3B%20(Consecutively%20not%20simultaneously)%3C%2FP%3E%3CP%3ENB%3A%3C%2FP%3E%3CUL%3E%3CLI%3EIn%20a%20split%20window%2C%20you%20can%20%3CSTRONG%3Edrag%20the%20Vertical%20or%20Horizontal%20Divider%3C%2FSTRONG%3Ewith%20your%20mouse%20to%20a%20different%20location.%3C%2FLI%3E%3CLI%3EYou%20Can%20also%20%3CSTRONG%3Escroll%20each%20Section%3C%2FSTRONG%3EUp%20%26amp%3B%20Down%20using%20the%20wheel%20of%20your%20mouse.%20BUT%20(look%20at%20that)%20you%20can%20also%20scroll%20Left%20and%20Right%20by%20%3CFONT%20color%3D%22%230000FF%22%3E%3CSTRONG%3EPUSHING%20DOWN%3C%2FSTRONG%3E%3C%2FFONT%3Ethe%20wheel%20of%20the%20mouse%20and%20drag%20!!%3C%2FLI%3E%3CLI%3EYou%20can%20%3CSTRONG%3Eremove%3C%2FSTRONG%3Eone%20(or%20both%20)%20divider%20quickly%20by%20Double%20clicking%20on%20it.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787246%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787246%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20suggestion%2C%20Nabil%2C%20but%20I've%20already%20tried%20this.%26nbsp%3B%20I%20attempted%20to%20say%20so%20in%20my%20original%20post%2C%20but%20I%20wasn't%20clear%20enough.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20divide%20the%20pane%20into%20left%20and%20right%20sections%20with%20a%20slider%20for%20each%20that%20would%20control%20their%20vertical%20motions%20independently.%20In%20other%20words%2C%20I%20want%20the%20left%20side%20to%20stay%20in%20position%20while%20I%20move%20the%20right%20side%20up%20and%20down.%20Although%20the%20Excel%20option%20you%20described%20does%20have%20two%20vertical%20sliders%2C%20they%20control%20the%20top%20and%20bottom%20sections.%20When%20you%20use%20one%20or%20the%20other%2C%20the%20left%20and%20right%20quadrants%20slide%20together.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787301%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787301%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385141%22%20target%3D%22_blank%22%3E%40Ken_Stewart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Ken%3C%2FP%3E%3CP%3EThat's%20also%20possible%20to%20scroll%20vertically%20on%20one%20side%20but%20this%20time%20we'll%20use%20a%20different%20functionality%3A%3C%2FP%3E%3COL%3E%3CLI%3EOpen%20the%20Excel%20File%20to%20the%20desired%20Sheet%3C%2FLI%3E%3CLI%3EClick%20on%20the%20View%20Tab%20%26gt%3B%26gt%3B%20Click%20on%20New%20Window%20(now%20you%20have%202%20versions%20of%20the%20same%20sheet%20open)%3C%2FLI%3E%3CLI%3EOn%20the%20View%20Tab%20%26gt%3B%26gt%3B%20Click%20on%20%22Arrange%20All%22%20%26gt%3B%26gt%3B%20Select%20Vertical%20%26gt%3B%26gt%3B%20OK%3C%2FLI%3E%3CLI%3ENow%20the%20Command%20%22View%20Side%20By%20Side%20%22%20is%20highlighted%3C%2FLI%3E%3CLI%3EOn%20the%20View%20Tab%20%26gt%3B%26gt%3B%20DESELECT%20%26gt%3B%26gt%3B%20%3CSTRONG%3E%22Synchronous%20Scrolling%22%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EYou%20should%20be%20able%20to%20scroll%20each%20view%20independently%20of%20the%20other%20one%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787474%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787474%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20again%2C%20Nabil%2C%20but%20I've%20also%20tried%20this.%20I%20gave%20reasons%20in%20my%20original%20post%20why%20this%20isn't%20a%20satisfactory%20solution.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787913%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385141%22%20target%3D%22_blank%22%3E%40Ken_Stewart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20don't%20think%20there's%20a%20way%20of%20doing%20what%20you%20want%20to%20do%20sorry%20Ken%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787935%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787935%22%20slang%3D%22en-US%22%3E%3CP%3EI%20suspect%20you're%20right%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%2C%20but%20I%20wanted%20to%20give%20the%20Community%20a%20shot%20at%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-790557%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20split%20panes%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385141%22%20target%3D%22_blank%22%3E%40Ken_Stewart%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20for%20you%20my%20friend%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Ken_Stewart
New Contributor

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.

7 Replies

@Ken_Stewart 

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:

  1. Select any cell (You will be splitting Above and to the Left of the selected cell)
  2. View Tab >> Click Split >> Enjoy
  3. 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 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.

@Ken_Stewart 

Hi Ken

That's also possible to scroll vertically on one side but this time we'll use a different functionality:

  1. Open the Excel File to the desired Sheet
  2. Click on the View Tab >> Click on New Window (now you have 2 versions of the same sheet open)
  3. On the View Tab >> Click on "Arrange All" >> Select Vertical >> OK
  4. Now the Command "View Side By Side " is highlighted
  5. On the View Tab >> DESELECT >> "Synchronous Scrolling"
  6. You should be able to scroll each view independently of the other one

 

Hope that Helps

Nabil Mourad

Thanks again, Nabil, but I've also tried this. I gave reasons in my original post why this isn't a satisfactory solution.

Solution

@Ken_Stewart 

 

I don't think there's a way of doing what you want to do sorry Ken

 

I suspect you're right, @Wyn Hopkins, but I wanted to give the Community a shot at it.

@Ken_Stewart 

Good for you my friend @Wyn Hopkins 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies