📊 Excel Shortcuts — Part 3

This part focuses on Formatting Shortcuts — quickly format cells, numbers, rows, and columns without repeatedly using the ribbon.

🟢 Basic Formatting

1️⃣ Ctrl + B → Bold

2️⃣ Ctrl + I → Italic

3️⃣ Ctrl + U → Underline

4️⃣ Ctrl + 1 → Open Format Cells dialog box

5️⃣ Ctrl + 5 → Apply / remove strikethrough

🔵 Number Formatting

6️⃣ Ctrl + Shift + ~ → General format

7️⃣ Ctrl + Shift + $ → Currency format

8️⃣ Ctrl + Shift + % → Percentage format

9️⃣ Ctrl + Shift + # → Date format

🔟 Ctrl + Shift + @ → Time format

1️⃣1️⃣ Ctrl + Shift + ! → Number format with commas and two decimal places

🟣 Rows & Columns

1️⃣2️⃣ Ctrl + Shift + + → Insert cells, rows, or columns

1️⃣3️⃣ Ctrl + - → Delete selected cells, rows, or columns

1️⃣4️⃣ Alt + H + O + A → AutoFit row height

1️⃣5️⃣ Alt + H + O + I → AutoFit column width

🟠 Useful Formatting Actions

1️⃣6️⃣ Alt + H + H → Open Fill Color menu

1️⃣7️⃣ Alt + H + FC → Open Font Color menu

1️⃣8️⃣ Ctrl + Shift + & → Apply border

1️⃣9️⃣ Ctrl + Shift + _ → Remove border

2️⃣0️⃣ Ctrl + E → Center-align text

💡 Real-World Example

Suppose you receive a raw sales report.

Instead of manually formatting everything:

➡️ Select the header → Ctrl + B

➡️ Format sales as currency → Ctrl + Shift + $

➡️ Format percentages → Ctrl + Shift + %

➡️ AutoFit columns → Alt + H + O + I

➡️ Insert a new column → Ctrl + Shift + +

➡️ Open detailed formatting options → Ctrl + 1

🧠 Double Tap ❤️ For More