Learn excel shortcut πΉ Ctrl + Z β Undo last action
πΉ Ctrl + Y β Redo last undone action
πΉ Ctrl + C β Copy
πΉ Ctrl + X β Cut
πΉ Ctrl + V β Paste
πΉ Ctrl + F β Find text or values π
πΉ Ctrl + H β Replace text or values
πΉ Ctrl + A β Select entire worksheet
πΉ Ctrl + Space β Select entire column
πΉ Shift + Space β Select entire row
πΉ Ctrl + D β Fill down
πΉ Ctrl + R β Fill right
πΉ Ctrl + T β Convert range to Excel Table
πΉ Ctrl + Shift + L β Toggle Filters ON / OFF
πΉ Ctrl + Page Down β Move to next worksheet
πΉ Ctrl + Page Up β Move to previous worksheet
πΉ Ctrl + Home β Jump to cell A1
πΉ Ctrl + End β Go to last used cell
πΉ Ctrl + Arrow Keys β Jump to data edges
πΉ Ctrl + Shift + Arrow Keys β Select data block
πΉ Ctrl + ; β Insert todayβs date
πΉ Ctrl + Shift + : β Insert current time
πΉ Ctrl + 1 β Open Format Cells dialog
πΉ Alt + = β Auto-insert SUM
πΉ Alt + Enter β New line inside a cell
πΉ Alt + A + E β Text to Columns
πΉ Alt + A + M β Remove duplicates
πΉ Alt + H + O + I β A...
Suggested Credits
Tags, Events, and Projects