Datasheet

For your convenience, Excel 2007 adds a mini-toolbar above the contextual
menu with useful commands drawn from the Ribbon, as shown in Figure 1-2.
See
also
“Introducing the Ribbon,” later in this part.
Using the keyboard
Most users will be comfortable using the mouse to do all their work in Excel. For
users who prefer to use the keyboard exclusively when working in Windows
applications or for users who prefer to split the use of the mouse and keyboard
among various tasks, Excel provides the following solutions.
 Keyboard shortcuts
 Keyboard navigation
 KeyTips
The first two functions are described next. For more on the last function,
KeyTips,
see “Tipping off your keyboard,” later in this part.
You can access commands in Excel using keyboard shortcuts, which are individ-
ual keystrokes or a combination of keys pressed simultaneously. To access the
Print command using a shortcut, for example, you press and hold down the Ctrl
key and press the P key, represented in this book as Ctrl+P. The following table
lists some common keyboard shortcuts in Excel.
Shortcut Action
Ctrl+A Select all
Ctrl+B Apply or remove bold formatting
Ctrl+C Copy selection
Figure 1-2
6 Part 1: Getting to Know Excel 2007
03_046716 ch01.qxp 11/16/06 6:40 PM Page 6