Microsoft Office Tutorials and References
In Depth Information
Arranging Worksheet Windows
INSIDE OUT Open a workbook in a separate process? Not so fast . . .
When you create a new workbook or open a previously saved workbook in Excel, the
new workbook file runs in the same Excel.exe process as the one you started with. That
makes it possible for you to arrange separate workbooks within the same program
window. If you’re running Windows 7, you can open a new instance of Excel in a separate
process by holding down the Shift key as you click the Excel icon on the taskbar. That
opens a new, blank workbook. It looks just like the other workbooks you’ve already
opened, and you can switch to it with Alt+Tab or by pointing to the Excel taskbar
button and clicking its preview. But if you look on the Processes tab in Task Manager, you’ll
see a second instance of Excel.exe. And if you click Switch Windows (on the View tab)
in the workbook you just opened, you’ll see that the newly created process doesn’t
see any of your existing workbook windows. If you like to arrange windows for easier
working, that alone is reason to avoid this technique.
The Tiled option arranges workbooks most efficiently, with the currently selected
workbook on the left and additional workbooks stacked up in a checkerboard pattern. If you
have three (or more) open workbooks to arrange, this is your best choice. The
Horizontal and Vertical options arrange all open workbooks from top to bottom or side by side,
respectively. Confusingly, the View Side By Side button in the Window group arranges two
worksheet windows one over the other (not side by side). If you have three or more
workbooks open, you’re prompted to choose which one you want to compare with the current
workbook.
What if you want to see two tabs from the same worksheet side by side? Start by clicking
the workbook you want to see in a second window, and then click New Window on the
View tab. That opens a second view of the current workbook and worksheet, appending
a colon and a number to each window. (Each window contains the same file. Any changes
you make in either window are reflected immediately in the other window.) If you use the
Arrange All button, each instance is treated like any other open workbook. To ignore all
other workbooks and just arrange multiple copies of the current window, click Arrange All,
select Windows Of Active Workbook, and then click OK.
Search JabSto ::




Custom Search