Splitting the window
Another way to change the view is by splitting the window â€“ otherwise known as splitting the screen. The screen can be split either horizontally or vertically or both. This allows you to have up to four portions of the spreadsheet in view at any one time.
Why would you want to do this? Imagine you have a large spreadsheet and one of the cells has a number in it which is used by three formulas in other cells. Using the split screen technique, you can position the cell containing the number in one section and each of the cells with formulas in the other sections. Then you can change the number in the cell and watch how it affects each of the formulas.