O'Reilly logo

Excel® 2007 Bible by John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix D. Excel Shortcut Keys

Many users have discovered that using their keyboard can often be much more efficient than using their mouse. This appendix lists the most useful shortcut keys available in Excel. The shortcuts are arranged by context.

The keys listed assume that you’re not using the Transition Navigation Keys, which are designed to emulate Lotus 1-2-3. You can select the Transition Navigation Keys option in the Advanced tab of the Excel Options dialog box. This option is in the Lotus Compatibility section.

New Feature

On the surface, the new Ribbon interface in Excel 2007 appears to be designed for a mouse. However, you can access nearly all the Ribbon commands by using the keyboard. Press the Alt key, and Excel displays “key tips” next to each command. Just press the key that corresponds to the command you need. For example, the command to toggle worksheet gridlines is View New Feature Show/Hide New Feature Gridlines. The keyboard equivalent is Alt, followed by WVG. Note that you don’t need to keep the Alt key depressed while you type the subsequent letters.

Table D.1. Moving Through a Worksheet

Key(s)

What It Does

Arrow keys

Moves left, right, up, or down one cell

Home

Moves to the beginning of the row

Home[*]

Moves to the upper-left cell displayed in the window

End[*]

Moves to the lower-left cell displayed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required