MICRO SOFT EXCEL SHORT CUT KEYS
SHORTCUT KEY | ACTION |
CTRL+A | SELECT ALL |
CTRL+B | BOLD |
CTRL+C | COPY |
CTRL+D | FILL DOWN |
CTRL+F | FIND |
CTRL+G | GOTO |
CTRL+H | REPLACE |
CTRL+I | ITALIC |
CTRL+K | INSERT HYPERLINK |
CTRL+N | NEW WORKBOOK |
CTRL+O | OPEN |
CTRL+P | |
CTRL+R | FILL RIGHT |
CTRL+S | SAVE |
CTRL+U | UNDERLINE |
CTRL+V | PASTE |
CTRL W | CLOSE |
CTRL+X | CUT |
CTRL+Y | REPEAT |
CTRL+Z | UNDO |
SHIFT | HOLD DOWN SHIFT FOR ADDITIONAL FUNCTIONS IN EXCEL’S MENU |
SHIFT+F1 | WHAT’S THIS? |
SHIFT+F2 | EDIT CELL COMMENT |
SHIFT+F3 | PASTE FUNCTION INTO FORMULA |
SHIFT+F4 | FIND NEXT |
SHIFT+F5 | FIND |
SHIFT+F6 | PREVIOUS PANE |
SHIFT+F8 | ADD TO SELECTION |
SHIFT+F9 | CALCULATE ACTIVE WORKSHEET |
CTRL+ALT+F9 | CALCULATE ALL WORKSHEETS IN ALL OPEN WORKBOOKS, REGARDLESS OF WHETHER THEY HAVE CHANGED SINCE THE LAST CALCULATION. |
CTRL+ALT+SHIFT+F9 | RECHECKS DEPENDENT FORMULAS AND THEN CALCULATES ALL CELLS IN ALL OPEN WORKBOOKS, INCLUDING CELLS NOT MARKED AS NEEDING TO BE CALCULATED. |
SHIFT+F10 | DISPLAY SHORTCUT MENU |
SHIFT+F11 | NEW WORKSHEET |
SHIFT+F12 | SAVE |
CTRL+F3 | DEFINE NAME |
CTRL+F4 | CLOSE |
CTRL+F5 | XL, RESTORE WINDOW SIZE |
CTRL+F6 | NEXT WORKBOOK WINDOW |
SHIFT+CTRL+F6 | PREVIOUS WORKBOOK WINDOW |
CTRL+F7 | MOVE WINDOW |
CTRL+F8 | RESIZE WINDOW |
CTRL+F9 | MINIMIZE WORKBOOK |
CTRL+F10 | MAXIMIZE OR RESTORE WINDOW |
CTRL+F11 | INSET 4.0 MACRO SHEET |
CTRL+F12 | FILE OPEN |
ALT+F1 | INSERT CHART |
ALT+F2 | SAVE AS |
ALT+F4 | EXIT |
ALT+F8 | MACRO DIALOG BOX |
ALT+F11 | VISUAL BASIC EDITOR |
CTRL+SHIFT+F3 | CREATE NAME BY USING NAMES OF ROW AND COLUMN LABELS |
CTRL+SHIFT+F6 | PREVIOUS WINDOW |
CTRL+SHIFT+F12 | |
ALT+SHIFT+F1 | NEW WORKSHEET |
ALT+SHIFT+F2 | SAVE |
ALT+= | AUTOSUM |
CTRL+` | TOGGLE VALUE/FORMULA DISPLAY |
CTRL+SHIFT+A | INSERT ARGUMENT NAMES INTO FORMULA |
ALT+DOWN ARROW | DISPLAY AUTOCOMPLETE LIST |
ALT+’ | FORMAT STYLE DIALOG BOX |
CTRL+SHIFT+~ | 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++ | INSERT |
CTRL+- | DELETE |
CTRL+1 | FORMAT CELLS DIALOG BOX |
CTRL+2 | BOLD |
CTRL+3 | ITALIC |
CTRL+4 | UNDERLINE |
CTRL+5 | STRIKETHROUGH |
CTRL+6 | SHOW/HIDE OBJECTS |
CTRL+7 | SHOW/HIDE STANDARD TOOLBAR |
CTRL+8 | TOGGLE OUTLINE SYMBOLS |
CTRL+9 | HIDE ROWS |
CTRL+0 | HIDE COLUMNS |
CTRL+SHIFT+( | UNHIDE ROWS |
CTRL+SHIFT+) | UNHIDE COLUMNS |
ALT OR F10 | ACTIVATE THE MENU |
CTRL+TAB | IN TOOLBAR: NEXT TOOLBAR |