![]() #BEYOND COMPARE EXCEL FILES WINDOWS#You can view multiple windows within Excel by clicking the Restore button for the current window. Excel is able to display multiple documents. This means all Excel files/windows are opened in the same application window. These versions of Excel used the Multiple Document Interface (MDI). If you're using Excel 2010 or earlier for Windows then the process for viewing multiple windows is slightly different. I'll do a dedicated post on this in the future.Īnd a big thanks to Andre for pointing out the issue with closing window “-2” first. I posted a macro in the comment below that apples the gridline settings for each sheet to the new window. If you close the “-1” window and then make changes to the workbook, you will lose the gridline and freeze pane settings that are applied to each sheet. This is an unfortunate limitation of Excel. The new window does not retain the settings for gridlines or freeze panes. Close the “-2” Window First!Įven though you can close either window, it's best to close the “-2” window first. You will only be prompted to save when you close the last remaining window for the file. You will NOT be prompted to save the file when you close the additional window. The “-2” will disappear after the file name and you will be left with only one window open for the file. ![]() This will just close the additional window, and NOT close the file. Once you are finished, you can simply close either of the windows by pressing the red X in the top right of the application window. See the video above for more details on this issue.Īnd just so you know, you can also use Synchronous Scrolling with two different workbooks as well. This is the case whether you are using the up and down arrows on your keyboard, the scroll bar in either of the windows, or the roller wheel on your mouse. Once your windows are side by side and you've clicked the Synchronous Scrolling button, you will see how both sheets scroll simultaneously. When you click on View Side by Side, it tends to reset any split screen setup you already had, so you may need to drag your window to the right again to see them side by side. You can do this by clicking the button directly above Synchronous Scrolling. If so, you need to turn on View Side by Side. The Synchronous Scrolling Button may be grayed out. To turn on synchronous scrolling, just go to the View tab on the Ribbon and choose the Synchronous Scrolling button. 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. #BEYOND COMPARE EXCEL FILES MAC#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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |