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 windows. Generally when you start Microsoft Excel 2010, a blank workbook appears with the provisional title Book1. The only exceptions occur when you start Excel by opening an existing workbook or when you have one or more Excel files stored in the XLStart folder so that they open automatically.
If you start Excel 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.
Note
For more about working with multiple windows, see Opening Multiple Windows for the Same Workbook on page 185. For more information about the XLStart folder, see Opening Files When You Start Excel on page 64.
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 name on the Switch Windows menu, which lists as many as nine open workbooks or, if you have more than nine open, displays a More Workbooks command that presents a dialog box listing all the open workbooks.
Tip
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 user interface. Users of older versions of Excel have grown used to the MDI, where you can have multiple workbooks open, but only one icon appears in the Windows system tray. Excel 2007 switched to the SDI paradigm, which continues in Excel 2010: Each open workbook creates a new icon in the system tray. A new workbook that appears when you first start Excel (or when you click the File tab and then click New) disappears when you open another workbook unless you have actually edited it. Then, when you click the Close button in the Excel title bar, Excel exits even though you may have thought you had another workbook open to prevent Excel from exiting.
The way to change this default SDI behavior is to click the File tab, click Options, select the Advanced category, and in the Display group clear the Show All Windows In The Taskbar check box. If you still prefer the SDI approach, you can work around this issue by avoiding clicking the Close button and instead clicking the File tab and then Close, which closes the active workbook but keeps the program open. You can also click the Close button in the workbook window instead of the Close button in the Excel window, or you can develop the habit of typing a space character (or any character) in cell A1 as soon as you start Excel just to keep Book1 alive.
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 patchwork of open documents. Figure 7-2 shows the same workbooks in the Horizontal configuration.
Note
You’ll find the 2011 Projections.xlsx, Humongous2010.xlsm, Team Sales 2011.xlsx, Regional Sales 2010.xlsx, and Pacific Sales 2011.xlsm files with the other examples on the companion Web site.
Figure 7-1. Clicking View, Arrange All opens the Arrange Windows dialog box, which gives you a choice of configurations.
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 have multiple windows open for one of them and want to arrange only these windows without closing the other workbooks.
Note
For more information about working with multiple worksheets from one workbook, see Opening Multiple Windows for the Same Workbook on page 185.
Note
If you’re working with several workbooks in a particular arrangement that is often useful, click the View tab, and then click Save Workspace in the Window group. This preserves the current settings so that you can re-create the window arrangement by opening one file. For more information, see Saving the Entire Workspace on page 60.
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, Excel removes the formula bar, status bar, Quick Access Toolbar, and ribbon from your screen—everything except the maximized workbook. To return the screen to its former configuration, press Esc.
Note
For more about maximizing and minimizing windows, see Resizing the Window on page 25.
The Full Screen button provides a convenient way to display the most information on the screen without changing the magnification of the data using the Zoom controls. For more information, see Zooming Worksheets on page 167.
Note
When you save a workbook, Excel also saves its characteristics, such as the window’s size, position on the screen, and display settings. The next time you open the workbook, the window looks the same as it did the last time you saved it. When you open it, Excel even selects the same cells you had selected when you saved the file.
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 essentially packages the Horizontal window arrangement option with a couple of useful features to make comparison chores a lot easier. The View Side By Side button lives in the Window group on the View tab; it is the top button located to the left of the Save Workspace command, as shown in Figure 7-3.
Note
The ribbon on your screen might look different from what you see in this book. The ribbon’s display adjusts to the size of your screen, its resolution, and the size of the Excel window. For example, the six buttons in the middle of the Window group on the View tab may or may not display adjacent text labels depending on your screen’s size and resolution and whether Excel is maximized.
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 performs its trick on no more or less than two windows. After you click the button, you see a Compare Side By Side dialog box like the one shown in Figure 7-3 if you have more than two windows open. If so, select the window you want to compare, and click OK; this opens the window and arranges it along with the window that was active when you clicked View Side By Side. (The button name is a little bit misleading because the windows are actually arranged horizontally—not really “side by side,” but one above the other.)
After you activate “side-by-side mode,” the two buttons below the View Side By Side button become active, as shown in Figure 7-4. The Synchronous Scrolling button locks the two windows together wherever they happen to be; when you scroll in any direction, the inactive window scrolls in an identical fashion. This action is activated automatically when you turn on the View Side By Side feature. The Reset Window Position button puts the active window on top, which is handy. The window that is active when you first click the View Side By Side button is the one that appears on top. If you want the other window on top, click anywhere in the other window, and then click the Reset Window Position button to place it in the top position.
The View Side By Side button is a toggle. To turn off side-by-side mode and return to Normal view, click the View Side By Side button again. Make sure you turn it off before moving on to other tasks to avoid some odd window behavior.