This is especially helpful if you need to compare line by line, looking for differences in similar sets of data. One cool feature to employ while using a split screen is that you can scroll both sheets at the same time. Note: This behavior is slightly different in Excel 2010 and earlier. I encourage you to check it out and see how you can improve your productivity game with split screens. I've written a whole post about tips for split screen usage for both Windows and Mac users. If you have multiple windows open on your computer, you may have to select which window you want to view on the left. To tile the windows side by side, you can simply click on the title bar and then drag the window to the right of the screen. This is a very handy shortcut that makes it easy to flip between windows (sheets) when doing common actions like copy & paste. You can then quickly flip between windows by using the Alt + Tab You can now select a different sheet in the new window to view and edit it. It does NOT matter which window you make changes in. Any change you make to the workbook in one window will be reflected in the other. Keep in mind that you are NOT creating a duplicate file, just a new window to look at the same file.

The new window will have a dash and the number 2 (then 3, 4, 5 and so on as you continue to open new windows). Once you've created a new window, you can differentiate between the new and the old by looking at the title bar at the top. The keyboard shortcut to open a new window is Alt + W + N.

This will create a new window of the active workbook (the workbook you were viewing when you pressed New Window). To make a new window, go to the View tab on the Ribbon and press the New Window button.

We can view two or more sheets from the same workbook by using the New Window feature. It's a fairly easy habit to pick up and will save you lots of time and frustration in the long run. To accomplish this, we can use the New Window feature in Excel, as well as some desktop shortcuts to create a split screen view of the the sheets we want to look at simultaneously. In these instances, it can be much easier to look at the two (or more) sheets side by side.

Sometimes we need to flip back and forth between two worksheets in order to compare numbers, copy and paste entries, or create formulas.

Mac excel 2013 freeze big file