Excel All Shortcut Keys

Excel Shortcut Keys

SHORTCUT WITH ALT KEYS ALT + F1 → INSERT CHART ALT + F2 → SAVE AS ALT + F4 → EXIT ALT + F8 → MACRO DIALOG BOX ALT + F11 → VISUAL BASIC EDITOR ALT + TAB → CYCLE APPLICATIONS ALT + = → AUTOSUM ALT + ¹ → FORMAT STYLE DIALOG BOX INSERT → TOGGLE INSERT MODE DELETE → DELETE HOME → MOVE TO BEGINNING OF LINE END → MOVE TO END OF LINE PAGE UP → PAGE UP PAGE DOWN → PAGE DOWN LEFT ARROW → LEFT RIGHT ARROW → RIGHT UP ARROW → UP DOWN ARROW → DOWN TAB → INDENT ENTER → NEXT CELL BACKSPACE → DELETE PREV CHAR   SHORTCUT WITH ALT & CTRL KEYS ALT + A → GO TO THE DATA TAB ALT + F → OPEN THE FILE MENU ALT + H → GO TO THE HOME TAB ALT + M → GO TO THE FORMULA TAB ALT + N → GO TO THE INSERT TAB ALT + P → GO TO THE PAGE LAYOUT TAB ALT + W → GO TO THE VIEW TAB ALT + H, A, C → CENTER ALIGN CELL CONTENTS ALT + H, D, C → DELETE COLUMN ALT + H, H → CHOOSE A FILL COLOR CTRL + END → GO TO THE END OF A DOCUMENT CTRL + SHIFT + > → INCREASE SELECTED FONT +1 SHIFT + INS → PASTE THE SELECTED ITEM CTRL + SHIFT + F → CHANGE THE FONT CTRL + INS → COPY THE SELECTED ITEM CTRL + DEL → CUT SELECTED ITEM   SHORTCUT WITH CTRL KEYS CTRL + F3 → NAME MANAGER CTRL + F4 → CLOSE CTRL + F5 → RESTORE DOWN CTRL + F9 → MINIMIZE WINDOW CTRL + F10 → RESTORE DOWN/ MAXIMIZE WINDOW CTRL + F11 → INSET 4.0 MACRO SHEET CTRL + F12 → OPEN FILE CTRL + SPACE → TO SELECT THE ENTIRE COLUMN CTRL+ SHIFT + 9 → TO UNHIDE SELECTED ROW SHIFT + SPACE → TO SELECT THE ENTIRE ROW

A TO Z EXCEL SHORTCUT CTRL + A → SELECT ALL CELL CTRL + B → BOLD CTRL + C → COPY CTRL + D → FILL DOWN CTRL + E → FLASH FILL CTRL + F → FIND CTRL + G → GO TO SPECIAL CTRL + H → FIND & REPLACE CTRL + I → ITALIC TEXT CTRL + J → NA CTRL + K → INSERT HYPERLINK CTRL + L → CREATE TABLE CTRL + M → NA CTRL + N → NEW WORKBOOK CTRL + O → OPEN FILE CTRL + P → PRINT CTRL + Q → DATA ANALYSIS TOOL CTRL + R → FILL DUPLICATE RIGHT CTRL + S → SAVE WORKBOOK CTRL + T → CREATE TABLE CTRL + U → UNDERLINE TEXT CTRL + V → PASTE CTRL + W → CLOSE WORKBOOK CTRL + X → CUT CTRL + Y → REDO CTRL + Z → UNDO CTRL + O → HIDE COLUMNS 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 + - → DELETE CTRL + + → INSERT   FUNCTION KEY SHORTCUTS F1 → HELP F2 → EDIT F3 → PASTE NAME F4 → REPEAT LAST ACTION F5 → GOTO F6 → NEXT PANE F7 → SPELL CHECK F8 → EXTEND MODE F9 → RECALCULATE ALL WORKBOOKS F10 → ACTIVATE MENUBAR F11 → NEW CHART F12 → SAVE AS 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 SHIFT + F10 → DISPLAY SHORTCUT MENU SHIFT + F11 → NEW WORKSHEET SHIFT + F12 → SAVE SHIFT + TAB → TO MOVE TO THE PREVIOUS CELL TAB → TO MOVE TO THE NEXT CELL CTRL + ; → TO INSERT THE CURRENT DATE