EXCEL SHORTCUT KEY

CTRL Shortcuts
CTRL + A Select All
CTRL + B Bold
CTRL + C Copy
CTRL + C, ALT E+S Paste Special
CTRL + D Fill Down
CTRL + F Find
CTRL + G Go to
CTRL + H Replace
CTRL + I Italic
CTRL + K Insert Hyperlink
CTRL + N New Workbook
CTRL + O Open File
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 + Y Repeat
CTRL + Z Undo
CTRL + 1 Format Box
CTRL + 5 Strike-through
CTRL + 7 Hide/show toolbar
CTRL + 9 Hide row
SHIFT + CTRL + 9 Unhide row
CTRL + 0 Hide column
SHIFT + CTRL + 0 Unhide column
CTRL + ~ Show formulas/values
CTRL + ‘ Copy above formula
CTRL + ; Display date
SHIFT + CTRL + : Display time
CTRL + [ Precedents
CTRL + ] Dependents
CTRL + Enter Fill selection w/ entry
Formatting Shortcuts
ALT + ‘ Display style
CTRL + 1 Format Box
SHIFT + CTRL + ~ General format
SHIFT + CTRL + ! Number format
SHIFT + CTRL + @ Time format
SHIFT + CTRL + # Date format
SHIFT + CTRL + $ Currency format
SHIFT + CTRL + % Percentage format
SHIFT + CTRL + ^ Exponential format
SHIFT + CTRL + & Outline border
SHIFT + CTRL + _ Remove border
SHIFT + CTRL + * Select region
Tools > Customize > Options Show full menus
Navigation and Data Editing
Arrow keys Move to new cells
ALT + Display a drop-down list
ALT + Tab Switch programs
CTRL + Pg Up/Down Switch worksheets
CTRL + Tab Switch workbooks
CTRL + Arrow keys Go to end of contiguous range
SHIFT + Arrow keys Select a cell range
SHIFT + CTRL + Arrow keys Highlight contiguous range
Home Move to beginning of row
CTRL + Home Move to cell “A1”
F5 “Go to”
ENTER Move to cell below
SHIFT + ENTER Move to cell above
TAB Move to cell to the right
SHIFT + TAB Move to cell to the left
BACKSPACE Delete cell and get inside
DELETE Delete cell/selection
F2 Edit/ highlight dependent cells
When inside cell…
ALT + ENTER Start new line in same cell
SHIFT + Arrow keys Highlight within cells
SHIFT + CTRL + Arrow keys Highlight contiguous items
BACKSPACE Delete preceding character
DELETE Delete character to the right
F4 Anchor “Fix” Cells
ESC Cancel a cell entry
F7 Spell check
SHIFT + F2 Insert a comment
CTRL + F3 Name a cell
ALT Shortcuts
ALT + Tab Switch program
ALT + ‘ Display style
ALT + T + O Options Menu
ALT + T + I Add-Ins Menu
ALT + E + S Paste special box
ALT + E + S + T Paste format only
ALT + W + S (Un)split panes
ALT + W + F (Un)freeze windows
ALT + E + M Move/ Copy a sheet
ALT + E + L Delete worksheet
ALT + V + Z Change view sizing
ALT + O + C + A Fit column width
ALT + O + H + R Change tab name
ALT + E + A Clears cell
ALT + F + V Print preview
ALT + F4 Close program
ALT + F8 Macro box
ALT + F11 Visual basic editor
Columns and Rows
SHIFT + Spacebar Highlight row
CTRL + Spacebar Highlight column
SHIFT + ALT + Group rows/columns
SHIFT + ALT + Ungroup rows/columns
CTRL + Minus sign Delete selected cells
SHIFT + CTRL + Plus Sign Insert blank cells
Formulas and Auditing
= (equals sign) Start a formula
SHIFT + F3 Display “Insert Function” box
ALT + “=“ Insert AutoSum formula
CTRL + ‘ (apostrophe) Copy formula from above cell
SHIFT + CTRL + “ (quote) Copy value from above cell
CTRL + ~ Show formulas/values
F9 Recalculate all workbooks
Auditing formulas…
ALT + T + U + T Trace immediate precedents
ALT + T + U + D Trace immediate dependents
ALT + T + U + A Remove tracing arrows
CTRL + [ Go to precedent cells
CTRL + ] Go to dependent cells
SHIFT + CTRL + { Trace all precedents (indirect)
SHIFT + CTRL + } Trace all dependents (indirect)
F5 + Enter Go back to original cell
Function Key Shortcuts
F1 Excel Help Menu
F2 Edit cells
F3 Paste Name
F4 Repeat or anchor cells
F5 “Go to”
F6 Next pane in split mode
F7 Spell check
F8 Anchor to highlight
F9 Recalculate workbooks
F10 Activate menu bar
F11 New chart
F12 Save as
SHIFT + F2 Insert a comment
SHIFT + F3 “Insert Function” Box
SHIFT + F4 Find Next
SHIFT + F5 Find
SHIFT + F6 Previous pane
SHIFT + F8 Add to selection
SHIFT + F9 Calculate active sheet
SHIFT + F10 Display shortcut menu
SHIFT + F11 New worksheet
CTRL + F3 Name a cell
CTRL + F4 Close window
CTRL + F9 Minimize workbook
CTRL + F10 Maximize window
CTRL + F12 Open File
Windows Flag + D Minimize program

Windows Flag + E Windows explorer