Datasheet

Keys Action
Ctrl+Home Moves the active cell to the beginning of worksheet (A1)
F5 Displays the Go To dialog box
Ctrl+Backspace Scrolls the screen to display the active cell
Up arrow* Scrolls the screen one row up (active cell doesn’t change)
Down arrow* Scrolls the screen one row down (active cell doesn’t change)
Left arrow* Scrolls the screen one column left (active cell doesn’t change)
Right arrow* Scrolls the screen one column right (active cell doesn’t change)
* With Scroll Lock on
Introducing the Ribbon
Excel 2007 comes with a new user interface that replaces the standard menus
and toolbars found at the top of the window in previous versions of Excel. The
new interface is called the Ribbon and consists of a series of tabs, each contain-
ing a variety of commands grouped according to function (see Figure 1-3).
Virtually all the features in Excel 2007 are available through the commands in
the Ribbon tabs. This arrangement allows you to discover features in the pro-
gram far more easily than if you had to drill down several layers into menus.
Dissecting the parts of the Ribbon
The commands in the Ribbon are accessed through a variety of controls. Here’s a
list of the various types of controls and other parts that make up the Ribbon:
 Button: This is the most common type of control. Most buttons in the
Ribbon (except the formatting ones) have descriptive text associated with
them, so you don’t need to be a Mensa expert to figure out what a button
represents. The most frequently used commands in each Ribbon tab have
larger buttons.
Contextual tab header
Home tab
Split button Dialog launcher Contextual tabs
Figure 1-3
8 Part 1: Getting to Know Excel 2007
03_046716 ch01.qxp 11/16/06 6:40 PM Page 8