I appreciate the split screen feature in Excel. It works especially well for very long worksheet where I need to keep the top visible while scrolling down the page.
Very easy way to enable the split:
- Hover the mouse over the top end of the scroll bars until the cursor changes into two vertical arrows
- Drag down to split the screen.
- To remove the split, simply drag the line back up to the top.
- You can also split the screen horizontally using the same method.
Now, what if you need to work on one worksheet while viewing another in the same workbook? The solution is not so obvious.
- Go to View -> New Window in the ribbon
- Now you will have two copies of the same file open.
- To view both at the same time, you can tile them. In the View tab, click “Arrange All”
- Choose how you would like to tile the windows.
Here are two windows tiled using the “vertical” option. Notice that the title bar for each file identifies the window:
Now, when you make changes to either of the windows, the other window will be updated. In other words, you are not opening a separate copy of the file, just a new view.