![]() ![]() 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 |