Contents
An Introduction to Keyboard Shortcuts and KeyTips
Shortcuts for Basic Excel Actions
Shortcuts for Navigating Excel Documents
Shortcuts for Selecting, Finding, and Replacing Cells, Text, and Data
Shortcuts for Copying and Moving Text and Data
Shortcuts for Inserting and Deleting Cells, Text, Data, and Graphics
Shortcuts for Formatting Cells and Text
Shortcuts for Working with Numbers and Data
Shortcuts for Printing Spreadsheets
Shortcuts for Reviewing, Protecting, and Sharing
Function Key Quick Reference
Learn more with these titles from Barnes & Noble
 |
- How to use Excel’s new KeyTips shortcut feature
- How to create your own custom keyboard shortcuts
- The keyboard shortcuts for hundreds of popular Excel commands
|
 |
|
 |
 |
|
An Introduction to Keyboard Shortcuts and KeyTips
A keyboard shortcut is a combination of two or three keystrokes that you can use to execute a command in a computer program more quickly than you could by clicking with a mouse. This guide covers the most helpful and popular keyboard shortcuts in Excel® 2007—except for the shortcuts to commands that are new to Excel 2007, the shortcuts in this guide apply to earlier versions of Excel as well.
How to Use Excel with Only Your Keyboard
Excel 2007’s KeyTips feature is a keyboard-based system that allows you to use Excel without even touching the mouse. KeyTips are different from keyboard shortcuts in that they can involve up to five keys per combination.
How to Use KeyTips
To use KeyTips, press the Alt key—little letters and numbers will appear next to the various commands on the screen. Hit the appropriate key (or keys) to use the command. For instance, to get to the Ribbon’s Home tab, you’d type Alt+H. Once there, a new set of letters and numbers appear that mark the Home tab commands. Press those keys to execute those commands. To make the shortcut numbers and letters disappear, hit the Alt key again.
Overlap Between KeyTips and Keyboard Shortcuts
Traditional keyboard shortcuts and Alt-key commands may sometimes overlap. For instance, you can save files using the keyboard shortcut Ctrl+S or the KeyTip Alt+F, S. This guide focuses on Excel’s keyboard shortcuts but lists helpful KeyTips where appropriate.
How to Make Custom Keyboard Shortcuts
In addition to providing hundreds of built-in keyboard shortcuts, Excel 2007 lets you create new shortcuts or modify existing ones by recording actions as a macro. To record a macro, follow the steps below:
- Click the Record Macro icon
located at the bottom left of the main Excel window. - The Record Macro dialog box opens. Give the Macro a name and assign it a shortcut key. The “Store macro in” field should say Personal Macro Workbook. Click OK.
- Go to the View tab. At the far right, click the Macro drop-down and select Use Relative References.
- Do the action for which you’d like to make a shortcut.
- Click the Stop Record button
at the bottom left of the main Excel window. - To use the macro, press the shortcut key you assigned to it in step 2.
If you’re using an earlier version of Excel, you can access the tools for recording Macros through the Tools drop-down menu.
| Acknowledgments & Disclaimer |
Download & Print this Quamut to Go
Complete 4-page Quamut to Go PDF only $2.95
