Chapter 3: Essential Worksheet Operations
53
l (^) Choose File ➪ Close.
l Click the Close button (the X icon) on the workbook window’s title bar. If the workbook
window is maximized, its title bar is not visible, so its Close button appears directly below
the Excel Close button.
l (^) Press Ctrl+W.
When you close a workbook window, Excel checks whether you made any changes since the last
time you saved the file. If you have made changes, Excel prompts you to save the file before it
closes the window. If not, the window closes without a prompt from Excel.
Activating a worksheet ..............................................................................................
At any given time, one workbook is the active workbook, and one sheet is the active sheet in the
active workbook. To activate a different sheet, just click its sheet tab, located at the bottom of the
workbook window. You also can use the following shortcut keys to activate a different sheet:l Ctrl+PgUp: Activates the previous sheet, if one existsl (^) Ctrl+PgDn: Activates the next sheet, if one exists
If your workbook has many sheets, all its tabs may not be visible. Use the tab scrolling controls
(see Figure 3.3) to scroll the sheet tabs. The sheet tabs share space with the worksheet’s horizontal
scroll bar. You also can drag the tab split control to display more or fewer tabs. Dragging the tab
split control simultaneously changes the number of tabs and the size of the horizontal scroll bar.
Tip
When you right-click any of the tab scrolling controls, Excel displays a list of all sheets in the workbook. You
can quickly activate a sheet by selecting it from the list. n
FIGURE 3.3
Use the tab controls to activate a different worksheet or to see additional worksheet tabs.
Tab scrolling controls Tab split control