EXCEL KEYBOARD SHORTCUTS (TEXT-FRIENDLY CHEAT SHEET)

============================================================
BASIC NAVIGATION

Arrow Keys ............. Move one cell
Ctrl + Arrow ........... Jump to edge of data region
Home .................... Go to start of row
Ctrl + Home ............ Go to A1
Ctrl + End ............. Go to last used cell
Page Up / Page Down .... Move one screen
Alt + Page Up/Down ..... Move one screen left/right

============================================================
SELECTING

Shift + Arrow .......... Select one cell at a time
Ctrl + Shift + Arrow ... Select to edge of data region
Ctrl + A ............... Select entire worksheet
Ctrl + Space ........... Select entire column
Shift + Space .......... Select entire row
Ctrl + Shift + Space ... Select entire table or used region

============================================================
EDITING & ENTERING DATA

Enter .................. Confirm entry & move down
Shift + Enter .......... Confirm entry & move up
Tab .................... Move right
Shift + Tab ............ Move left
Esc .................... Cancel entry
Ctrl + D ............... Fill down
Ctrl + R ............... Fill right
Ctrl + ; ............... Insert today's date
Ctrl + Shift + ; ....... Insert current time
Ctrl + Shift + + ....... Insert new row/column
Ctrl + - ............... Delete row/column

============================================================
COPY, PASTE, UNDO

Ctrl + C ............... Copy
Ctrl + X ............... Cut
Ctrl + V ............... Paste
Ctrl + Z ............... Undo
Ctrl + Y ............... Redo
Ctrl + Alt + V ......... Paste Special
F4 ..................... Repeat last action

============================================================
FORMULAS

=  ..................... Start a formula
Tab .................... Accept function autocomplete
Ctrl + ` (backtick) .... Toggle show formulas
F2 ..................... Edit active cell
Shift + F9 ............. Calculate active worksheet
F9 ..................... Calculate selected part of formula

============================================================
WORKBOOK & FILE

Ctrl + N ............... New workbook
Ctrl + O ............... Open
Ctrl + S ............... Save
F12 .................... Save As
Ctrl + W ............... Close file
Ctrl + P ............... Print

============================================================
WORKSHEET TABS

Ctrl + Page Up ......... Previous sheet
Ctrl + Page Down ....... Next sheet
Shift + F11 ............ Insert new worksheet
Alt + H + D + S ........ Delete worksheet (sequential keys)

============================================================
ROWS & COLUMNS

Ctrl + Shift + + ....... Insert row or column
Ctrl + - ............... Delete row or column
Ctrl + 0 ............... Hide column
Ctrl + Shift + 0 ....... Unhide column
Ctrl + 9 ............... Hide row
Ctrl + Shift + 9 ....... Unhide row

============================================================
FORMATTING

Ctrl + B ............... Bold
Ctrl + I ............... Italic
Ctrl + U ............... Underline
Ctrl + 1 ............... Format Cells dialog
Alt + H + O + I ........ AutoFit column width (sequential)
Alt + H + O + A ........ AutoFit row height (sequential)
Ctrl + Shift + $ ....... Currency format
Ctrl + Shift + % ....... Percent format
Ctrl + Shift + # ....... Date format

============================================================
FIND & REPLACE

Ctrl + F ............... Find
Ctrl + H ............... Replace
Ctrl + Shift + F ....... Find formatting
Ctrl + Shift + H ....... Replace formatting

============================================================
TABLES, FILTERS, SORT

Ctrl + T ............... Create table
Ctrl + Shift + L ....... Toggle filters
Alt + A + S + A ........ Sort ascending (sequential)
Alt + A + S + D ........ Sort descending (sequential)

============================================================
MISC

Alt ..................... Show Ribbon shortcuts
Ctrl + Shift + U ........ Expand/collapse formula bar
F7 ...................... Spell check
F11 ..................... Create chart from data
Alt + Enter ............. New line within cell