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
|
 |
 |
 |
|
Shortcuts for Working with Numbers and Data
Applying a Number Format to Selected Cells
Action |
Keyboard Shortcut |
|
Apply the General Number format |
Ctrl+Shift+~ |
|
Apply the Currency format (two decimal places, negative numbers appear in parentheses) |
Ctrl+Shift+$ |
|
Apply the Percentage format (no decimal places) |
Ctrl+Shift+% |
|
Apply the Exponential Number format (two decimal places) |
Ctrl+Shift+^ |
|
Apply the Date format (day, month, year) |
Ctrl+Shift+# |
|
Apply the Number format (two decimal places, thousands separator, minus sign (-) for negative values) |
Ctrl+Shift+! |
|
Apply the Time format (hour, minute, and AM or PM) |
Ctrl+Shift+@ |
Adding Formulas and Functions
Action |
Keyboard Shortcut |
|
Switch between cell values and formulas |
Ctrl+` |
|
Copy a formula from the above cell into the active cell or Formula Bar |
Ctrl+’ |
|
Open the Function Arguments dialog box |
Ctrl+A (when the cursor is to the right of the function name in a formula) |
|
Insert an argument’s name and parentheses |
Ctrl+Shift+A (when the cursor is to the right of the function name in a formula) |
|
Expand or shrink the formula bar |
Ctrl+Shift+U |
|
Open the Insert Function dialog box |
Shift+F3 |
|
Open the AutoSum functions menu |
Alt+M, U |
|
Sum data in the selected cells |
Alt+Equal Sign |
|
Open the Recently Used functions menu |
Alt+M, R |
|
Open the Financial functions menu |
Alt+M, I |
|
Open the Logical functions menu |
Alt+M, L |
|
Open the Text functions menu |
Alt+M, T |
|
Open the Date & Time functions menu |
Alt+M, E |
|
Open the Lookup & Reference functions menu |
Alt+M, O |
|
Open the Math & Trig functions menu |
Alt+M, G |
|
Open the More Functions functions menu |
Alt+M, Q |
Performing Calculations
Note: These shortcuts work only if Automatic Calculation is turned off. To turn Auto Calculation off or on, click on Calculation Options in the Formulas tab.
Action |
Keyboard Shortcut |
|
Calculate all sheets in all open workbooks |
F9 |
|
Calculate the current worksheet only |
Shift+F9 |
|
Verify formulas, then calculate all open workbooks |
Ctrl+Alt+Shift+F9 |
Inserting the Current Date and Time Into Cells
To Insert . . . |
Keyboard Shortcut |
|
The current time (based on your computer’s clock) |
Ctrl+Shift+: |
|
The current date (based on your computer’s calendar) |
Ctrl+; |
| Acknowledgments & Disclaimer |
for just $2.95
► Handy, portable format
