New Window for Second View
Spreadsheets can be enormous, and you may have to interact with different areas of the spreadsheet at what seems like the same time, such as cutting and pasting info from the top to the bottom over and over. If it's hundreds of thousands of cells, the scrolling that would take could make you nauseous. Or, you could just open a second window on your desktop with a view of exactly the same spreadsheet. It's easy. In the View tab, click New Window. You can also click Arrange All to get them ordered on screen in a way that works for you. You can see them Horizontally arranged above. Then, type something into a cell in one window, you can see it appear in the other window. This trick is especially handy if you've got dual monitors.