Sunday, May 3, 2026

Computer excel shortcuts

 🔹 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