Microsoft Office Tutorials and References
In Depth Information
The Excel User Interface
and check out the shortcuts listed in Excel’s Help system. (Search for keyboard shortcuts using
the Search box or locate the topic under the Accessibility chapter of Help’s Table of Contents.)
The Help system contains tables that summarize useful keyboard commands and shortcuts.
To ease the transition from previous versions, Microsoft includes the Office 2003 Access Key
feature. Many Excel users are accustomed to navigating the old menu system with their keyboard,
and they would become much more inefficient if they had to rely on the new Ribbon. If you type
an Alt+ letter sequence that isn’t a part of the Ribbon but that did exist in Excel 2003, you get a
ScreenTip near the top of the Excel window, like the one shown in Figure 1-7.
Figure 1-7: Using a keyboard sequence like Alt+I+R (for Insert
Row) can still be used to insert a row and
will display this ScreenTip during the process.
Customized on-screen display
Excel offers some flexibility regarding on-screen display (status bar, Formula bar, the Ribbon,
and so on). For example, by choosing View
Full Screen, you can get rid of
everything except the title bar, thereby maximizing the amount of visible information. To get out
of full-screen mode, right-click and select Exit Fullscreen from the shortcut menu (or press Esc).
A little less drastic is pressing the Ctrl+F1 shortcut key to hide (and restore) the Ribbon.
The status bar at the bottom of the screen can be customized. Right-click the status bar, and you
see lots of options that allow you to control what information is displayed in the status bar.
Many other customizations can be made by choosing File
Options and clicking the Advanced
tab. On this tab are several sections that deal with what displays on-screen.
Data entry in Excel is quite straightforward. Excel interprets each cell entry as one of the following:
h A value (including a date or a time)
h A Boolean value (TRUE or FALSE)
h A formula
Formulas always begin with an equal sign (=).