Split Windows
- 01:31
Learn how to split your worksheet into separate windows with the Split Windows tool
Downloads
Glossary
Reading Reports ScrollingTranscript
The split windows shortcut is Alt + W + S. And what's splitting your worksheet allows you to do is look at multiple distant parts of the worksheet all at the same time. So in our example here, you'll notice that we can see rows 6 through 22 and then also rows 58 onwards as well. So there's a split after row 22, which means you can jump around the worksheet much more easily. Sometimes when you're working on a model, you might want to look at different parts of the same sheet at exactly the same time. So in this example here, what I want to be able to do is look at both the assumptions for the income statement and the income statement at the same time. But the problem is the assumptions are up here and the income statement is right down in row 44. So what I'm going to do is I'm going to make sure I can see my assumptions first, then go down to row 12, and I'm going to use the split screen shortcut Alt + W + S. Okay, so now I can see my assumptions, and you can see there's this split here. Now if I'm in the second section, the lower section, I can scroll down. You'll notice that I can always see down to row 11 from the top there. I can keep on going down until I can see my income statement. There's my income statement. Fantastic. And now all I need to do is play around with these assumptions and I can see what's happening as I adjust them.