In early versions of Microsoft Excel, worksheets,
This chapter describes how to protect workbooks, how to use more than one workbook at a time, and how and why to split your view of a workbook into multiple
If you start Excel with Book1 visible and then open an existing Excel file, Book1 disappears unless you have edited it. You can open as many workbooks as you like until your computer runs out of memory.
For more about working with multiple windows, see " Opening Multiple Windows for the Same Workbook " on page 171. For more information about the XLStart folder, see " Opening Files When You Start Excel " on page 65.
If you have more than one workbook open, you can activate a particular workbook in any of the following three ways:
Click its window, if you can see it.
If you have all your workbook windows maximized, you can shuffle through the open workbooks by pressing Ctrl+Tab to activate each workbook in the order you opened them. Press Shift+Ctrl+Tab to activate them in reverse order.
On the View tab on the Ribbon, click a window
Inside Out-Closing the Last Open Excel Window
Over the past few releases of Office, there has been some debate about the relative merits of the multiple document interface (MDI) and the single document interface (SDI). What are we talking about here? It's a difference in how documents are handled in the
The way to change this default SDI behavior is to click the Microsoft Office Button, click Excel Options, select the Advanced category, and in the Display
To make all open workbooks visible at the same time, click the View tab, and click Arrange All. Excel displays the Arrange Windows dialog box, shown in Figure 7-1, which also shows the workbooks arranged in the Tiled configuration with the screen divided into a
Figure 7-1: Clicking View, Arrange All opens the Arrange Windows dialog box, which gives you a choice of configurations.
Figure 7-2: These windows are arranged in the Horizontal configuration.
On the CD You'll find the 2008 Projections.xlsx , Humongous08.xlsm , and Pacific Sales.xlsm files in the Sample Files section of the companion CD.
If you select the Windows Of Active Workbook check box in the Arrange Windows dialog box, only the active workbook is affected by the configuration setting, and then only if more than one window is open for the active workbook. Excel arranges those windows according to the option you select under Arrange in the Arrange Windows dialog box. This is handy if you have several workbooks open but you have multiple windows open for one of them and you want only to arrange these windows without closing the other workbooks.
For more information about working with multiple worksheets from one workbook, see " Opening Multiple Windows for the Same Workbook " on page 171.
If you're working with several workbooks in a particular arrangement that is often useful, click the View tab, and click Save Workspace in the Window group. This
You can maximize the workbook window if you need to see more of the active worksheet, but if that still isn't enough, you can click the Full Screen button on the View tab. When you do so, Excel
Figure 7-3: Clicking View, Full Screen hides the formula bar, status bar, Quick Access Toolbar, and Ribbon to maximize the screen space available for viewing your data.
To return the screen to its former configuration, press Esc.
For more about maximizing and minimizing windows, see " Resizing the Window " on page 29.
The Full Screen button provides a
When you save a workbook, Excel also saves its characteristics, such as the window's
The Arrange All button on the View tab is extremely helpful if you need to compare the contents of two similar workbooks, but another feature makes this task even easier. The View Side By Side button
Figure 7-4: If more than two windows are open, select one in the Compare Side By Side dialog box.
The Ribbon on your screen may look different from what you see in this book. The Ribbon display
You can click the View Side By Side button to arrange any two open windows, even if they are windows for the same workbook (as described in the next section). But unlike the Arrange button, View Side By Side
Figure 7-5: The Synchronous Scrolling button locks side-by-side window scrolling.
After you activate "side-by-side mode, " the two buttons below the View Side By Side button become active, as shown in Figure 7-5. The Synchronous Scrolling button locks the two windows together wherever they happen to be so when you scroll in any direction, the inactive window
The View Side By Side button is a toggle-to