EXCEL SHORTCUT LIST
FORMATING SHORTCUTS
CTRL +1 FORMAT BOX
ALT + E + S + T COPY FORMAT
ALT + H + 0 INCREASE DECIMAL
ALT H + 9 DECREASE DECIMAL
CTRL + SHIFT +7 BOXING
ALT + O + C + A FIT COLUMN WIDTH
ALT + H + O + R CHANGE TAB NAME
ALT + W + F (UN)FREEZE WINDOWS
SHIFT + CTRL + # DATE FORMAT
SHIFT + CTRL +$ $ DOLLAR FORMAT
SHIFT + CTRL + % % PERCANTAGE FORMAT
ALT + = SUM FUCTION
FUCTION KEY SHORTCUTS
F2 EDIT CELLS
F4 ANCHOR CELLS
F7 SPEL. CHECK
F12 SAVE AS
SHIFT + F2 INSERT A COMMENT
SHIFT + F8 ADD TO SELECTION
SHIFT + F3 RIGHT CLICK
CTRL + 3 NAME A CELL
WINDOWS + D MINIMIZE PROGRAMS
CTRL Shortcuts
CTRL + A SELECT ALL
CTRL + B BOLD
CTRL + C COPY
CTRL + D FILL DOWN
CTRL + F FIND
CTRL + I ITALIC
CTRL + N NEW WORKBOOK
CTRL + O OPEN
CTRL + P PRINT
CTRL + R FILL RIGHT
CTRL + S SAVE WORKBOOK
CTRL + U UNDERLINE
CTRL + V PASTE
CTRL + W CLOSE WINDOW
CTRL + X CUT
CTRL + Z UNDO
NAVIGATION SHORTCUTS
Arrows Move
CTRL + Arrows Go to End of Continuous Range
SHIFT + Arrows Select A Cell Range
CTRL + SHIFT + Arrows Highlight A Continuous Range
ALT + Tab Switch Programs
CTRL + PgUp/Down Switch Worksheets
Enter Move below
Shift + Enter Move Up
Home Move to Beginning of Line
CTRL + Home Go to Cell A1
ESC Cancel Alt + Enter (when in a cell) Add a Line
Columns & Rows Shortcuts
CTRL + 9 Hide Row
SHIFT + CTRL + 9 Unhide Row
CTRL + 0 Hide Column
SHIFT + CTRL + 0 Unhide Column
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
