Join Chris Grover for an in-depth discussion in this video Splitting the worksheet view and freezing panes, part of Learning Excel 2010.
Some spreadsheets are nice and compact and perfectly happy to fit on your computer screen, while others are big, unwieldy affairs and are a lot more difficult to view. This lesson shows how to view two different parts of your worksheet at once. So consider a worksheet like this one, that the spreadsheet keeps track of Google stock data, such as open, high, lows, and closing prices over different days. And if I scroll down, you can see it covers a few months. There's a lot of data there. And it goes off in this direction, too, if I scroll over to the right. But doesn't all fit on the screen at once.
Now what if I wanted to compare these November prices with some of the prices earlier in the year. I can't really fit them both on the screen at once. But what I can do is I can split the screen, and I do that by going up here and you see this little button above the scroll bar arrow. And if I drag that down it splits my screen and now my screen is in two parts You have a scroll bar for the upper part and a scroll bar for the bottom part. So I can go down here and look at my July and June data and compare it to my September data.
And that can be pretty handy when you have a worksheet that goes on forever. You can split your screen vertically too, just find the similar little button that's next to your scroll bar arrow and drag it over this way and you can split your screen vertically. You have scroll bars for each section down on the bottom here. And you can look at all different parts of your worksheet at once. When you're through with that view, you can go over here and you can drag these bars back to their little home and you're back looking at a single view. Now there's another way that you can reset it too. If I go to View, then I'll see that the Split Screen button is highlighted there. All I have to do to turn it off is click it, the highlight goes away, and so does the bar that splits the screen.
Now there's another command that's related to this that's really handy and it's called Freeze Panes. Often you'll want to freeze that first row in your spreadsheet, so that these headings appear here even though you scroll down to look at other data. The way to do that is, again, you go to the View tab, and you go over here to Freeze Panes, and choose Freeze Top Row. So now we see a little line below the top row, and when I scroll, that top row remains that you can see that row 1 still there even though we're down to row 32 over here. So that's really handy sometimes you'll want to do exactly the same thing with this first column over here.
So the thing to do is go View > Freeze Panes > Freeze First Column and now we can scroll on this direction. And that first column stays there but we can look at the rest of the data. To undo it I just go back here and click Unfreeze Panes, and we're back to the way we were. Now, one last thing, sometimes you'll want to see this top row and this first column at the same time, or maybe some other combination.
The way to do that is just to choose a cell that's right at the corner where you want to freeze the panes. Go up here, and just choose Freeze Panes, and now it splits the screen in a couple of directions, so we can see the top row. And we can see that first column. And they're displayed all the time. So in this lesson, you learned how to use Excel's Split Screen feature to view two parts of a worksheet at once. You also explored a related feature called Freeze Panes which is great for keeping specific rows and columns in view.
- Understanding Excel and its user interface
- Getting started with basic tasks
- Developing your spreadsheet
- Creating more complex formulas
- Making changes to your workbook
- Visualizing your data with color, charts, and graphics
- Analyzing data
- Printing and sharing your worksheet