Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting
the next and previous sheet, respectively, in your workbook.
If your workbook contains too many sheets for all the tabs to be displayed at
the bottom of the Worksheet area, use the Sheet Tab scroll buttons to bring
new tabs into view (so that you can then click them to activate them). You
click the Next Sheet button (the ellipsis or three periods to the left of the first
visible sheet) to scroll the next hidden sheet tab into view or the Last Sheet
button (the ellipsis or three periods to the left of the last visible sheet) to
scroll the last group of completely or partially hidden tabs into view.
To scroll the very first worksheet in the workbook into view, you can hold
down Ctrl as you click the left-pointing Sheet Tab scroll button. To scroll the
last sheet into view, you Ctrl+click the right-pointing scroll button.
To display the Activate dialog box that lists all the sheets in the workbook
from first to last, right-click either one of the Sheet Tab scroll buttons. You
can then scroll into view and click any of the sheets in the workbook simply
by clicking its name in the Activate dialog followed by clicking OK.
On a touchscreen device, remember that the touch equivalent of a right-click
with a mouse is to tap and press the graphic element on the screen — the
Sheet Tab scroll button in this case — until a circle appears around your
finger or stylus. When you then remove your finger or stylus from the screen,
the shortcut menu or, in this case, the dialog box associated with the graphic
Showing off the Status bar
The Status bar is the last component at the very bottom of the Excel program
window (see Figure 1-9). The Status bar contains the following:
✓ Mode indicator on the left that shows the current state of the Excel
program (Ready, Edit, and so on) as well as any special keys that are
engaged (Caps Lock, Num Lock, and Scroll Lock).
✓ AutoCalculate indicator that displays the average and sum of all the
numerical entries in the current cell selection along with the count of
every cell in the selection.
✓ Layout selector that enables you to select between three layouts for the
Worksheet area: Normal, the default view that shows only the worksheet
cells with the column and row headings; Page Layout View that adds