Join Dennis Taylor for an in-depth discussion in this video Splitting screens horizontally and vertically, part of Excel Essential Training (Office 365).
- [Teacher] Sometimes particularly working with large lists, you might wanna see information from different parts of this list, and they might be hundreds of rows apart. On this worksheet called Split Screen, in the workbook called 08- Worksheet Views, in this list there's a training group. And there are actually two or three different training groups. We might wanna be viewing the people's names from one group as well as those in the other group. And maybe those others are found down in row 500. These are around row 95. So what can we do here? There's a feature called split.
And we can split the screen either horizontally, allowing us to scroll independently above or below that split line. Also we can do it vertically. Let's first look at the horizontal version. This begins with this idea. We can be anywhere on the screen, but let's click over in column A, roughly halfway down. Then, on the view tab, choose split. Notice how it introduces a vertical line. And off to the right, we've got two scroll bars. So, in the top scroll bar, I'm gonna click the dropper over there, or drag the box, and I'm scrolling through the list, keep clicking that arrow over there.
And I forget where the data is, so I'm looking for it. There it is! I want some of those Admin Training names to appear there. And meanwhile, I've got another list, and I think it's around row 500. So, in the lower portion of the screen, I've got that other scroll bar over there, I'm gonna drag that down, into row 500 or thereabouts. And somewhere in there so I'm scrolling now with the mouse to find those records, there we are. I wanna see these together. I could zoom back now if I wanted to also. But we're looking at a completely different part of the same worksheet at the same time.
That's gonna be really handy at times. So after reviewing the data or using it for presentation purposes, we can get rid of the split. We can either double-click the line if we wish, or simply go back to the split command and the feature's gone. Now, at other times you might want to split the screen left right. Probably not as commonly used, but maybe you've got some data with lots of columns, and you're making a presentation. You wanna pull data together from different portions without necessarily hiding columns, something like that. Here too, we sort of arbitrarily click, this time in the top row, about halfway over or so.
Split, that introduces a vertical split. And now I've got two scroll bars at the bottom, for either side. On the left side we can scroll left and right, without disturbing what's happening on the right side. On the right side we can do the same kind of thing. So we're seeing columns A and J close to one another here, but they're actually different portions of the screen. And this is a little bit odd, because we've got them you know, in the wrong order so to speak. But that's viable, and you can work with it. We can move this line back and forth when necessary, if we wanna do that.
Sometimes that makes sense, sometimes not. Here too, if we no longer wanna use the feature, we'll double click the line or go back to the split command. Now, some people discover this feature in a way, and I remember doing it myself once, I had the active cell somewhere in the middle of the screen, and I clicked split, I'm trying to remember whether I did it on purpose or not, but if you do click split and you're not on the edge of the data, either top or left, we see a four-way split. And that means two scroll bars on the right side, and two on the bottom.
And this is almost a recipe for chaos. I'm gonna scroll on the upper portion right now, and then down the lower portion, just like we saw earlier. And then scroll independently on the right side, or the left side. And it's kinda confusing I think. To prove a point, I'm not sure how major this point is likely to be, but in the upper left corner here I've got cell A1. In the lower right quadrant, I'm gonna click one of these cells, double click the bottom edge, and to the bottom, control down arrow.
That's the very last row in any Excel worksheet. Control right arrow, there we are on the extreme lower right hand corner. If you can see that cell and cell A1 at the same time, what does that say? We could see any two cells in the worksheet at the same time. By way of this feature. But how often are you gonna need that? Probably not very often. We can get rid of the four-way split by double clicking the inner section, or simply as we've been doing go back to the split command. So click click, it's gone. Sometimes it doesn't work so smoothly.
Double click, and you've gotta be careful not to move the mouse as you do a double click. There we go. So it's a feature that you're more likely to use to split the screen horizontally, that was the first example we saw. Maybe not quite as often to split it vertically. But the split four-way, not so often. That's a feature that does give you that capability of seeing data if different parts of the worksheet at the same time.
- Working with the Excel interface
- Entering data
- Creating formulas and functions
- Formatting your data
- Adjusting rows and columns
- Finding and replacing data
- Inserting and deleting sheets
- Sorting and filtering data
- Creating charts and PivotTables
- Printing and sharing worksheets
- Protecting worksheets and workbooks
Skill Level Beginner
Q: This course was updated on 1/7/2019. What changed?
A: A new video was added that covers working with Excel Ideas.