Erudite & Savvy Academy

Contact us for professional assistance with ND, HND, BSc projects, term papers, proposals, datasets, and project topics at 08160647962. Let's talk business 💼📚👍💻🎓📝

🤔🤔🤔

BLESSED NOVEMBER TO US ALL 🎉🍁🌟

All Basic Excel "Ctrl" Shortcuts

🔷️ Ctrl + T — Convert selected range to Excel Table
🔷 Ctrl + Shift + L — Toggle autofilter
🔷 Alt + down arrow — Activate filter
🔷 Ctrl + Shift + T — Toggle table total row
🔷 Shift + Space — Select entire row
🔷 Ctrl + Space — Select entire column
🔷 Ctrl + A — Select entire worksheet
🔷 Shift + Click — Select adjacent cells
🔷 Ctrl + Click — Select non-adjacent cells
🔷 Shift + Backspace — Select active cell only
🔷 Ctrl + Backspace — Show the active cell
🔷 Ctrl + G — "Go To" specific cells
🔷 Ctrl + \ — Select row differences
🔷 Ctrl + Shift + | — Select column differences
🔷 Alt + ; — Select visible cells only
🔷 F2 — Edit the active cell
🔷 Alt + Enter — Insert line break
🔷 Ctrl + Enter — Enter same data in multiple cells
🔷 Ctrl + ; — Insert current date
🔷 Ctrl + Shift + ; — Insert current time
🔷 Ctrl + D — Fill Down
🔷 Ctrl + R — Fill Right
🔷 Ctrl + E — Flash fill
🔷 Ctrl + 1 — Format anything
🔷 Ctrl + Shift + & — Add border outline
🔷 Alt H B R — Add border Right
🔷 Alt H B L — Add border Left
🔷 Alt H B T —Add border Top
🔷 Alt H B B — Add border Bottom
🔷 Ctrl + Shift + - — Remove borders
🔷 F4 — Toggle absolute and relative references
🔷 Alt + = — Autosum selected cells
🔷 Ctrl + Shift + U — Expand or collapse formula bar
🔷 Ctrl + F1 — Expand or collapse ribbon
🔷 Shift + F11 — Insert new worksheet
🔷 Ctrl + PgDn — Go to next worksheet
🔷 Ctrl + PgUp — Go to previous worksheet
🔷 Ctrl + C — Copy
🔷 Ctrl + X — Cut
🔷 Ctrl + V — Paste
🔷 Ctrl + Z — Undo
🔷 Ctrl + Y — Redo
🔷 F4 — Repeat
🔷 Ctrl + N — Create new workbook
🔷 Ctrl + O — Open workbook
🔷 Ctrl + S — Save workbook
🔷 F12 — "Save As" workbook
🔷 Ctrl + P — Print
🔷 Ctrl + W — Close workbook
🔷 Alt + F4 — Close Excel

✨️ Quick Tip: Use Ctrl + T to instantly transform plain data into a smart Excel Table — with filters, sorting and automatic formula expansion. It's a must-use for every pro! 🚀