Share via

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

Anonymous
2024-01-05T23:51:01+00:00

I have two tables on a single worksheet in Excel. Table 1 is comprised of columns A-D, and Table 2 is comprised of columns F and G. I would like to be able to split my worksheet vertically on column E such that I can scroll Table 1 vertically while keeping Table 2 on screen without working in separate windows. Using the Freeze Panes or Split features under the View menu does not lock the individual panes vertically, only horizontally. Can this be done without working in multiple windows?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-20T08:19:09+00:00

    Hi Sola,

    I am using Word2016 at work and have the same issue following your directions as AlexB648 did. After following your directions I got the 4 way split (your directions actually gave me a vertical split right away but when it didnt work right I figured out how to get the 4 way split you described), then moved the horizontal split up to have only a vertical split. There are 2 horizontal scroll bars but only 1 vertical scroll bar even though the view is split vertically. So I have 2 vertical panes but they do not vertically scroll independently. which is what I need

    Microsoft Excel does not support independent vertical scrolling for split panes within the same worksheet. The current functionality allows for splitting the worksheet into panes, but scrolling vertically in one pane will affect the other pane as well​

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2024-01-09T16:52:31+00:00

    You did not not reply to the fact that only the right vertical pane has a vertical scroll-bar. So independent scrolling in the vertical direction is not possible.

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2024-01-06T02:38:02+00:00

    Hi Sola,

    Thanks for replying. I tried the steps you provided, but splitting at E1 creates just the vertical split, and the left pane does not have a separate vertical scroll bar. Is there a step I'm missing?

    8 people found this answer helpful.
    0 comments
  4. Anonymous
    2024-07-03T18:39:30+00:00

    Using split screen you can only have 2 vertical scroll bars if you split screen horizontally so that there is a top section and a bottom section. Then the top can scroll independently from the bottom.

    Sadly you can not split screen vertically and have a left and right scroll bar for each split.

    6 people found this answer helpful.
    0 comments
  5. Anonymous
    2024-03-14T19:24:05+00:00

    Hi Sola,

    I am using Word2016 at work and have the same issue following your directions as AlexB648 did. After following your directions I got the 4 way split (your directions actually gave me a vertical split right away but when it didnt work right I figured out how to get the 4 way split you described), then moved the horizontal split up to have only a vertical split. There are 2 horizontal scroll bars but only 1 vertical scroll bar even though the view is split vertically. So I have 2 vertical panes but they do not vertically scroll independently. which is what I need

    6 people found this answer helpful.
    0 comments