30/12/2025
🔹 Ctrl + F – Find text or values 🔍
🔹 Ctrl + H – Replace text or values
🔹 Ctrl + N – New workbook
🔹 Ctrl + O – Open workbook
🔹 Ctrl + S – Save workbook
🔹 Ctrl + W – Close current workbook
🔹 Ctrl + A – Select entire worksheet
🔹 Ctrl + C – Copy
🔹 Ctrl + X – Cut
🔹 Ctrl + V – Paste
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last action
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + T – Convert range to Excel Table
🔹 Ctrl + ; – Insert today’s date
🔹 Ctrl + Shift + : – Insert current time
🔹 Ctrl + 1 – Format Cells dialog
🔹 Ctrl + Shift + L – Toggle filters ON/OFF
🔹 Ctrl + Page Up – Previous worksheet
🔹 Ctrl + Page Down – Next worksheet
🔹 Ctrl + Arrow Keys – Jump to data edges
🔹 Ctrl + Shift + Arrow Keys – Select data block
🔹 Alt + = – Auto-insert SUM
🔹 Alt + Enter – New line inside a cell
🔹 Alt + H + O + I – Auto-fit column width
🔹 Alt + A + E – Text to Columns
🔹 Alt + A + M – Remove duplicates
🔹 Shift + Space – Select entire row
🔹 Ctrl + Space – Select entire column
---
✨ Quick Tip:
Use Ctrl + F to instantly search large datasets — combine it with filters to find results even faster!
IT Skills
