Keyboard shortcuts

Ctrl + Shift + $ – Currency format
Ctrl + Shift + @ – Time format
Ctrl + Page Down – Next sheet
Ctrl + Space – Select entire column
Ctrl + Shift + + (Plus) – Insert row/column
Alt + F8 – Open macro dialog
Ctrl + Shift + L – Toggle filters on/off
Ctrl + T – Create table
Alt + H + O + A – Auto-fit row height
Ctrl + Shift + ! – Number format
Ctrl + + (Plus) – Insert cells
Alt + H + O + I – Auto-fit column width
Alt + A + M – Remove duplicates
Alt + W + F – Freeze panes
Shift + Space – Select entire row
Ctrl + Shift + ~ – General number format
F9 – Calculate all worksheets
Ctrl + Page Up – Previous sheet
F2 – Edit active cell
Alt + W + S – Split window
Alt + N + V – Create PivotTable
Alt + Tab – Switch between applications
Ctrl + Shift + # – Date format
Ctrl + - (Minus) – Delete selection
Ctrl + F6 – Switch between workbooks
Alt + E + S + V – Paste special values
Shift + F3 – Insert function
Ctrl + F3 – Define name
Ctrl + Shift + % – Percentage format
F4 – Repeat last action
Ctrl + N: Quickly open a new workbook.
Ctrl + O: Effortlessly access an existing workbook.
Ctrl + S: Easily save your current workbook.
Ctrl + P: Print your document with a few keystrokes.
Ctrl + Z: Instantly reverse your last action.
Ctrl + Y: Reinstate the action you just reversed.
Ctrl + C: Duplicate selected cells or content.
Ctrl + X: Remove and relocate selected data seamlessly.
Ctrl + V: Immediately paste the copied or cut data.
Ctrl + F: Search for specific content in your workbook.
Ctrl + H: Substitute located content with something new.
Ctrl + A: Highlight all content in your worksheet.
Ctrl + B: Make your text bold for emphasis.
Ctrl + I: Italicize the chosen text.
Ctrl + U: Underline text for clarity.
Ctrl + Shift + L: Add or remove filters on your data.
Alt + =: Instantly calculate the sum of a cell range.
F2: Directly edit the active cell.
F4: Seamlessly repeat your last action.
F11: Generate a chart with a single button press.
Ctrl + Arrow Keys: Navigate through your data swiftly.
Ctrl + Space: Effortlessly select the entire column.
Shift + Space: Select the entire row in your worksheet.
Ctrl + D: Fill down data from the above cell.
Ctrl + R: Fill right from the adjacent cell.

Win+V Clipboard
Win+X X-menu
Win+Shift+S Scren Print
Ctrl+Shift+Esc: Opens the Task Manager

Leave a Reply

Your email address will not be published. Required fields are marked *