From the course: Excel 2019 Essential Training

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Splitting screens horizontally and vertically

Splitting screens horizontally and vertically

From the course: Excel 2019 Essential Training

Start my 1-month free trial

Splitting screens horizontally and vertically

- [Narrator] You can split your screen either horizontally, which will allow you to see different groups of rows above and below the split, or vertically, this will allow you to see different groups of columns to the left or to the right of the split. We're looking at a worksheet called Split Screen. Let's imagine that you want to see people from one of the departments here. Scrolling downward now, Admin Training. Now, you've got another training group much farther down the list, around row five hundred or thereabouts. We'd like to be able to see a portion of each of these, and maybe zooming back, we might be able to see all of them. So how do we begin the process? If we want to split the screen roughly 50-50, and it doesn't have to always be that, on the screen down on the left-hand side, click about halfway down or so and then, on the View tab in the Ribbon, choose Split. As we slide over the feature, notice the description: "Divide the window into different panes that each scroll…

Contents