Split screens either horizontally or vertically to allow independent scrolling up and down or left and right in different parts of the worksheet.
- [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 separately." And now we see a split line right here. You can click and drag, move this up or down if you need to. Notice on the right-hand side, we've got a scrollbar for the upper portion as well as for the bottom portion.
So on the upper portion, I'm gonna drag the scrollbox downward a bit. I'm looking at that Admin Training group. We don't necessarily need to see it all. And in the lower portion, I'm gonna scroll down somewhere near row five hundred down there. If the scrolling moves too fast for you, you can click the arrow at the bottom. It will move this way a little bit. Hold down the left mouse button. We're scrolling down here independently of the pane on top. So there's that Professional Training Group. We're viewing data roughly 'round 9,100 in those rows and down here, we see what's happened.
Different groups. So we can scroll independently on either side. If you no longer need the feature, or if you want to move the split line up or down, you can certainly do this if you don't need this anymore. You can either click that Split button again, or simply double-click the line, it disappears. Now, at other times you might wanna consider splitting the screen left and right. And here too, depending upon the nature of the data and what it is you're trying to see, sometimes simply zooming in and out might help, but let's say you need to see this large on the screen during presentation purposes.
At the bottom of the screen, we can zoom in if we wish. That's a different feature actually, but sometimes we wanna do that. Now, here too, somewhat arbitrarily, we click roughly halfway across the screen, Split, and now we see a vertical split. Here too, we could move this line leftward or rightward. But now we have two scrollbars at the bottom of the screen on each side. Now, on the left side, sometimes this might not be very big. If you do see the three dots down here, you can move that leftward.
But we're scrolling on the left side of the screen, but not on the right. Now, it would be a little bit unusual to say, "Let's scroll to the right, here, and let's go to the other window on the right side and scroll leftward," but we could certainly do that if we wanted to. It's probably a bit atypical, but we can scroll this way, and over on the left-hand side this way. Sometimes it might be better simply to hide the columns, the intervening columns, to see the data side-by-side this way. Here too, at some point, we no longer need the feature, double-click. Now, what happens sometimes is, and I'll zoom back a bit so you can see more data, sometimes you've got the active cell here or there.
Maybe you've never seen the feature at all. If you activate Split and you're not on the top row or the left column, you'll divide the window essentially into four separate panes. And now I've got two scrollbars on the right-hand side for vertical scrolling, We can certainly do that as we saw before. Over on the left hand-side side bottom, we've got a scrollbar this way. Now, I think much of the time, this is chaos, total chaos. Why would you ever wanna do this? To prove a point, you could, if you had to, you could see any two cells in the worksheet at the same time by experimenting with this feature.
I think most of us probably don't need this. Here too, to get rid of one or the other, simply double-click the line, or we can even point to the middle here, and although I don't really think we need to move this around this way, we can that. And if we simply wanna remove the feature, double-click. So I think for many people, the Split feature works best if you're dividing the screen left-right or top-bottom, but there could be that occasional use, rare use, of splitting the screen into four separate panes. It's a viable feature for when you want to view data in different parts of the same worksheet.
- Navigating Excel tabs and menus
- Entering data
- Creating formulas and functions
- Formatting rows, columns, cells, and data
- Working with alignment and text wrap
- Adjusting rows and columns
- Finding and replacing data
- Printing and sharing worksheets
- Creating charts and PivotTables
- Inserting and deleting sheets
- Using power functions such as IF and VLOOKUP
- Password-protecting worksheets and workbooks
- Sorting data
- Analyzing data with Goal Seek and Solver
- Creating and running macros