✅ Learn Basic & Advaced Ms Excel concepts for data analysis
✅ Learn Tips & Tricks Used in Excel
✅ Become An Expert
✅ Use The Skills Learnt Here In Your Career
For promotions: @love_data
Post #2341
2.46K
📊 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
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
- ❤ 14











