🔹 Ctrl + Shift + @ – Apply time format ⏰
🔹 Ctrl + Shift + $ – Apply currency format
🔹 Ctrl + Shift + % – Apply percentage format
🔹 Ctrl + Shift + # – Apply date format
🔹 Ctrl + Shift + ^ – Apply scientific format
🔹 Ctrl + 1 – Open Format Cells dialog
🔹 Ctrl + D – Fill down
🔹 Ctrl + R – Fill right
🔹 Ctrl + T – Convert range to Excel Table
🔹 Ctrl + Shift + L – Toggle Filters ON / OFF
🔹 Ctrl + A – Select entire worksheet
🔹 Ctrl + Space – Select entire column
🔹 Shift + Space – Select entire row
🔹 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 + F – Find
🔹 Ctrl + H – Replace
🔹 Ctrl + Z – Undo last action
🔹 Ctrl + Y – Redo last undone action
🔹 Alt + = – Auto-insert SUM
🔹 Alt + Enter – New line inside a cell
🔹 Alt + A + E – Text to Columns
🔹 F2 – Edit active cell
🔹 Shift + F11 – Insert new worksheet
✨ Quick Tip:
Use Ctrl + Shift + @ to quickly format time values correctly — especially useful for logs and timestamps.
#excelshortcuts
No comments:
Post a Comment