From the course: Excel 2013 Essential Training

Unlock the full course today

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

Splitting screens horizontally and vertically

Splitting screens horizontally and vertically - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Splitting screens horizontally and vertically

When working with large worksheets, it may be advantageous to see different portions of the worksheet at the same time. In this list here, we've got some entries here for the Admin Training group and later there's a Professional Training group. We might want to see some of those names together at the same time. You can split a screen vertically or horizontally or even both ways. If we want to split the screen top bottom horizontally, put the active cells somewhere in column A, no matter where you happen to be on the screen at any given time more or less around the middle, somewhere out here for example. And then, on the View tab in the Ribbon, choose Split. We split the screen top bottom. Here's the split line right here. We can move this up and down if we wish. Now recognize there's a scroll bar on the right-hand side that lets us scroll above the split line. Nothing is scrolling below the line though, so maybe we want to see some of those Admin Training people over there that we…

Contents