Microsoft Office Tutorials and References
In Depth Information
Activating a worksheet
Closing windows
If you have multiple windows open, you may want to close those windows that you no
longer need. Excel offers several ways to close the active window:
Choose File
Close.
Click the Close button (the X icon) on the workbook window’s title bar.
Press Alt+F4.
Press Ctrl+W.
When you close a workbook window, Excel checks whether you made any changes since the
last time you saved the fi le. If you have made changes, Excel prompts you to save the fi le
before it closes the window. If not, the window closes without a prompt from Excel. Oddly,
Excel provides no way to tell you if a workbook has been changed since it was last saved.
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:
Ctrl+PageUp: Activates the previous sheet, if one exists
Ctrl+PageDown: 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 14.2) to scroll the sheet tabs. The sheet tabs share space with the
worksheet’s horizontal scrollbar. You also can drag the tab split control (to the left of the
horizontal scrollbar) to display more or fewer tabs. Dragging the tab split control
simultaneously changes the number of tabs and the size of the horizontal scrollbar.
FIGURE 14.2
Use the tab scrolling controls to activate a different worksheet or to see additional
worksheet tabs.
Tab scrolling controls
Search JabSto ::




Custom Search