![]() With the CTRL + Tab shortcut, it’s very easy to navigate between the windows.Ī few additional notes about this technique: To flip to the other window, use the CTRL + Tab shortcut and then use the arrow keys to move to the link destination cell then hit Enter: To link the sheets, as usual type an “=” sign in the cell where you want to build a formula on the Model sheet. Step 3 – Start Working with Both Windows: To create an easy interface to link the Model sheet to the Scenarios sheet, simply move over the Scenarios sheet in one of the windows. If you choose Horizontal, it will look like this:Īs mentioned, anything you do in either window will be duplicated in the other. You can choose the view style you prefer. Step 2 – View Both Mirrors at the Same Time: To see both mirrors windows at the same time, go to the View tab and then select Arrange All: (Alt + W + A). For some reason, the newly created window does not adopt the same zoom size or gridline settings of the original one, but this can easily be changed manually. Any changes made in “:1” will be simultaneously appear automatically in “:2”. Rather, the New Window option creates a duplicative “mirror” of the file in a separate window. However, these two “files” are not actually different files. Notice that now in the Switch Windows area, there are two “files”, Medallion Model:1 and Medallion Model:2. This will automatically create a duplicate version of the file, as shown below. Step 1 – Create a Mirror Window of the File: Go to the View tab and select New Window (Alt W, N). ![]() Note that as seen in the Switch Windows area of the View tab, there is only one file open called “Medallion Model”: Let’s suppose you’re working on a model like the one pictured below. “Mirror, mirror on the wall….” Many of us struggle working with Excel files because you can only see one part of a file at a time…when you want to make a change to one part of a model and see the impact it has elsewhere, you have to flip over to the other section, right? Similarly, if you want to link a sheet to another sheet in the same file, you have to keep moving from sheet to sheet, right? Wouldn’t it be nice if you could work with two or more parts of a workbook, including different sheets, as “mirrors” or live separate windows, so that if you need to view them at the same time and easily switch between them, you can? Yes it would….and you can do it quite easily using some of the tools in the “Windows” section of “View” menu tab of Excel. How to Work Simultaneously in Multiple Parts of the Same Excel Workbook
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |