| Function |
Short cut |
| Select All |
Ctrl+A |
| Bold |
Ctrl+B |
| Copy |
Ctrl+C |
| Fill Down |
Ctrl+D |
| Find |
Ctrl+F |
| Goto |
Ctrl+G |
| Replace |
Ctrl+H |
| Italic |
Ctrl+I |
| Insert Hyperlink |
Ctrl+K |
| New Workbook |
Ctrl+N |
| Open |
Ctrl+O |
| Print |
Ctrl+P |
| Fill Right |
Ctrl+R |
| Save |
Ctrl+S |
| Underline |
Ctrl+U |
| Paste |
Ctrl+V |
| Close |
Ctrl W |
| Cut |
Ctrl+X |
| Repeat |
Ctrl+Y |
| Undo |
Ctrl+Z |
| Help |
F1 |
| Edit |
F2 |
| Paste Name |
F3 |
| Repeat last action |
F4 |
| While typing a formula, switch between absolute/relative refs |
F4 |
| Goto |
F5 |
| Next Pane |
F6 |
| Spell check |
F7 |
| Extend mode |
F8 |
| Recalculate all workbooks |
F9 |
| Activate Menubar |
F10 |
| New Chart |
F11 |
| Save As |
F12 |
| Insert Current Time |
Ctrl+: |
| Insert Current Date |
Ctrl+; |
| Copy Value from Cell Above |
Ctrl+” |
| Copy Formula from Cell Above |
Ctrl+’ |
| Hold down shift for additional functions in Excel’s menu |
Shift |
| What’s This? |
Shift+F1 |
| Edit cell comment |
Shift+F2 |
| Paste function into formula |
Shift+F3 |
| Find Next |
Shift+F4 |
| Find |
Shift+F5 |
| Previous Pane |
Shift+F6 |
| Add to selection |
Shift+F8 |
| Calculate active worksheet |
Shift+F9 |
| Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation. |
Ctrl+Alt+F9 |
| Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated. |
Ctrl+Alt+Shift+F9 |
| Display shortcut menu |
Shift+F10 |
| New worksheet |
Shift+F11 |
| Save |
Shift+F12 |
| Define name |
Ctrl+F3 |
| Close |
Ctrl+F4 |
| XL, Restore window size |
Ctrl+F5 |
| Next workbook window |
Ctrl+F6 |
| Previous workbook window |
Shift+Ctrl+F6 |
| Move window |
Ctrl+F7 |
| Resize window |
Ctrl+F8 |
| Minimize workbook |
Ctrl+F9 |
| Maximize or restore window |
Ctrl+F10 |
| Inset 4.0 Macro sheet |
Ctrl+F11 |
| File Open |
Ctrl+F12 |
| Insert Chart |
Alt+F1 |
| Save As |
Alt+F2 |
| Exit |
Alt+F4 |
| Macro dialog box |
Alt+F8 |
| Visual Basic Editor |
Alt+F11 |
| Create name by using names of row and column labels |
Ctrl+Shift+F3 |
| Previous Window |
Ctrl+Shift+F6 |
| Print |
Ctrl+Shift+F12 |
| New worksheet |
Alt+Shift+F1 |
| Save |
Alt+Shift+F2 |
| AutoSum |
Alt+= |
| Toggle Value/Formula display |
Ctrl+` |
| Insert argument names into formula |
Ctrl+Shift+A |
| Display AutoComplete list |
Alt+Down arrow |
| Format Style dialog box |
Alt+’ |
| General format |
Ctrl+Shift+~ |
| Comma format |
Ctrl+Shift+! |
| Time format |
Ctrl+Shift+@ |
| Date format |
Ctrl+Shift+# |
| Currency format |
Ctrl+Shift+$ |
| Percent format |
Ctrl+Shift+% |
| Exponential format |
Ctrl+Shift+^ |
| Place outline border around selected cells |
Ctrl+Shift+& |
| Remove outline border |
Ctrl+Shift+_ |
| Select the current region around the active cell. In a PivotTable report, select the entire PivotTable report. |
Ctrl+Shift+* |
| Insert |
Ctrl++ |
| Delete |
Ctrl+- |
| Format cells dialog box |
Ctrl+1 |
| Bold |
Ctrl+2 |
| Italic |
Ctrl+3 |
| Underline |
Ctrl+4 |
| Strikethrough |
Ctrl+5 |
| Show/Hide objects |
Ctrl+6 |
| Show/Hide Standard toolbar |
Ctrl+7 |
| Toggle Outline symbols |
Ctrl+8 |
| Hide rows |
Ctrl+9 |
| Hide columns |
Ctrl+0 |
| Unhide rows |
Ctrl+Shift+( |
| Unhide columns |
Ctrl+Shift+) |
| Activate the menu |
Alt or F10 |
| In toolbar: next toolbar |
Ctrl+Tab |
| In a workbook: activate next workbook |
| In toolbar: previous toolbar |
Shift+Ctrl+Tab |
| In a workbook: activate previous workbook |
| Next tool |
Tab |
| Previous tool |
Shift+Tab |
| Do the command |
Enter |
| Start a new line in the same cell. |
Alt+Enter |
| Fill the selected cell range with the current entry. |
Ctrl+Enter |
| Font Drop Down List |
Shift+Ctrl+F |
| Font tab of Format Cell Dialog box |
Shift+Ctrl+F+F |
| Point size Drop Down List |
Shift+Ctrl+P |
| Select the entire column |
Ctrl+Spacebar |
| Select the entire row |
Shift+Spacebar |
| Select the array containing the active cell. |
CTRL+/ |
| Select all cells that contain comments. |
CTRL+SHIFT+O |
| In a selected row, select the cells that don’t match the formula or static value in the active cell. |
CTRL+\ |
| In a selected column, select the cells that don’t match the formula or static value in the active cell. |
CTRL+SHIFT+| |
| Select all cells directly referenced by formulas in the selection. |
CTRL+[ |
| Select all cells directly or indirectly referenced by formulas in the selection. |
CTRL+SHIFT+{ |
| Select cells that contain formulas that directly reference the active cell. |
CTRL+] |
| Select cells that contain formulas that directly or indirectly reference the active cell. |
CTRL+SHIFT+} |
| Select the visible cells in the current selection. |
ALT+; |
| With multiple cells selected, select only the active cell. |
SHIFT+BACKSPACE |
| Selects the entire worksheet. |
CTRL+SHIFT+SPACEBAR |
| If the worksheet contains data, CTRL+SHIFT+SPACEBAR selects the current region. CTRL+SHIFT+SPACEBAR a second time selects the entire worksheet. |
| When an object is selected, CTRL+SHIFT+SPACEBAR selects all objects on a worksheet |
| Reapply the filter and sort on the current range so that changes you’ve made are included |
Ctrl+Alt+L |
| Displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. |
Ctrl+Alt+V |
Pro-Formats 