Excel Shortcut List.pdf

EXCEL SHORTCUT LIST Formatting Shortcuts Function Key Shortcuts CTRL + 1 Format Box F2 Edit Cells ALT + E + S + T Copy Format F4 Anchor Cells ALT + H + 0 Increase Decimal...

EXCEL SHORTCUT LIST Formatting Shortcuts Function Key Shortcuts CTRL + 1 Format Box F2 Edit Cells ALT + E + S + T Copy Format F4 Anchor Cells ALT + H + 0 Increase Decimal F7 Spell Check ALT + H + 9 Decrease Decimal F12 Save As CTRL + SHIFT + 7 Boxing SHIFT + F2 Insert a Comment ALT + O + C + A Fit Column Width SHIFT + F8 Add to Selection ALT + H + O + R Change Tab Name SHIFT + F10 Right Click ALT + W + F (Un)Split Panes CTRL + F3 Name a Cell ALT + W + S (Un)freeze windows Windows Flag + D Minimize Programs SHIFT + CTRL + # Date Format SHIFT + CTRL + $ $ Dollar Format SHIFT + CTRL + % % Percentage Format Navigation Shortcuts ALT + "=" Sum Function Arrows Move CTRL + Arrows Go to End of Continuous Range SHIFT + Arrows Select A Cell Range CTRL Shortcuts CTRL + SHIFT + Arrows Highlight A Continuous Range CTRL + A Select All ALT + Tab Switch Programs CTRL + B Bold CTRL + Pg Up/Down Switch Worksheets CTRL + C Copy Enter Move below CTRL + D Fill Down Shift + Enter Move Up CTRL + F Find Home Move to Beginning of Line CTRL + I Italic CTRL + Home Go to Cell A1 CTRL + N New Workbook ESC Cancel CTRL + O Open Alt + Enter (when i n a cel l ) Add a Line CTRL + P Print CTRL + R Fill Right CTRL + S Save Workbook Columns & Rows Shortcuts CTRL + U Underline CTRL + 9 Hide Row CTRL + V Paste SHIFT + CTRL + 9 Unhide Row CTRL + W Close Window CTRL + 0 Hide Column CTRL + X Cut SHIFT + CTRL + 0 Unhide Column CTRL + Z Undo SHIFT + Spacebar Highlight Row CTRL + Spacebar Highlight Column SHIFT + CTRL + Plus sign Insert Blank Cells CTRL + Minus Sign Delete Selected Cells SHIFT + ALT + Left Arrow Group Rows/Columns SHIFT + ALT + Right Arrow Ungroup Rows/Columns