Can Excel Worksheets be Split Vertically into Panes that Independently Scroll Vertically?

I don't think this can be done. I'm using the latest version of Office 365. I also tried Shollybee's direction and it does not work. Using a split at a cell position lower than A1 and any vertical position creates the four quadrants with two vertical and two horizontal scroll bars. The horizontal scroll bars will independently scroll each section to the left and right. The vertical scroll bar will scroll both screens up and down dependently (in sync) not independently. Moving the spit bar to the top row eliminates the top scroll bar resulting in only one vertical scroll bar.

Sholllybee, have you tried your method? I tried what you've indicated several times and cannot get it to work; it works as I've described above, which is there's only an independent horizontal (left and right) scroll option. Vertical scrolling only scrolls both screens. I remember this working on an earlier version of Excel. Any further clarification would be greatly appreciated!

Hi Alex,

Thanks for contacting us,

I can help you with your question about splitting Excel worksheets vertically into panes that independently scroll vertically.

The answer to your question is yes, you can split your worksheet vertically into two panes that can scroll independently in the vertical direction, without working in separate windows. To do this, you need to use the Split feature under the View tab, but with a slight modification. Here are the steps you can follow:

• Select the cell in column E and row 1, which is the intersection of the two tables you want to split. This will be the point where the split will occur.
• On the View tab, in the Window group, click Split. This will divide your worksheet into four panes, two horizontal and two vertical.
• To remove the horizontal split, drag the horizontal split bar to the top edge of the worksheet window. This will merge the top and bottom panes into one pane, leaving only the vertical split.
• To adjust the width of the panes, drag the vertical split bar to the left or right as you prefer. You can also double-click the split bar to fit the width of the columns in each pane.
• To scroll each pane independently, use the vertical scrollbars on the right side of each pane. You can also use the mouse wheel or the arrow keys to scroll up and down. The horizontal scrollbars will move both panes together, as they are aligned horizontally.

Let me know if this helps or if you need further assistance.

Regards, Sola

“Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below. “

Kindly note that this is a user to user forum, we are users helping other users, we aren't Microsoft employee neither are we Microsoft agents.

I also thought this answer was affirming the two panels side by side could be scrolled differently, but have not been able to replicate - no multiple vertical scrollbars.

There are two ways:

• click the button 'split' on the View-tab
• drag the vertical split-bar to the left

But AlexB648's question is still not answered (how to independently scroll vertically the two split-panes next to each other).

@shollybee or any one else: we hope you have the answer to that.

Hi again,

You're welcome. I'm glad to help.

Splitting at E1 should create both a horizontal and a vertical split, and each pane should have its own scroll bar. However, if you only see a vertical split, you may have accidentally dragged the horizontal split bar to the top of the window. You can try to drag it back down by moving your cursor to the top edge of the window until it changes to a double-headed arrow, then click and drag it down.

Alternatively, you can remove the split by clicking the Split button on the View tab, then click it again to create a new split at E1. You can also use the keyboard shortcut Alt+W+S to toggle the split on and off.