|
[ Go to 2,001 Tips Table of Contents ]
2,001 Tips
Applications
Spreadsheets
Excel 7.0
| TASK | SHORTCUT
|
| Open file | Ctrl+O |
| Print | Ctrl+P |
| Save | Ctrl+S |
| Undo last action | Ctrl+Z
|
| Repeat last action | F4
|
| Display Function Wizard | Shift+F3
|
| Insert blank cell | Ctrl+Shift+Plus sign
|
| Delete cell selection | Ctrl+Minus sign
|
| Edit cell note | Shift+F2
|
| Move down one screen | Page down
|
| Move up one screen | Page up
|
| Move right one screen | Alt+Page down
|
| Move left one screen | Alt+Page up
|
| Move to next workbook sheet | Ctrl+Page down
|
| Move to previous workbook sheet | Ctrl+Page up
|
| Move up through a selection | Shift+Enter
|
| Move right through a selection | Tab
|
| Move left through a selection | Shift+Tab
|
| Format selected element | Ctrl+1
|
| Check spelling | F7
|
| Enter date | Ctrl+Semicolon
|
| Enter time | Ctrl+Shift+Colon
|
| Calculate all sheets in all open workbooks |
F9 or Ctrl+Equal sign |
| Calculate active sheet | Shift+F9
|
| Insert AutoSum formula | Alt+Equal sign
|
| Insert new chart | F11
|
| Insert new worksheet | Shift+F11
|
| Apply percentage format | Ctrl+Shift+%
|
| Apply two-decimal-place format | Ctrl+Shift+!
|
| Format as currency | Ctrl+Shift+$
|
| Hide rows | Ctrl+9 |
| Unhide rows | Ctrl+Shift+(
|
| Hide columns | Ctrl+0 (zero)
|
| Unhide columns | Ctrl+Shift+)
|
[ Go to 2,001 Tips Table of Contents ]
|