🚀 Excel Basics & Interface — Part 3

🎨 Excel Formatting Essentials

Formatting makes your data easier to read, understand, and present professionally.

📌 In real jobs, good formatting can make the difference between an average report and an impressive dashboard.

📝 1. What is Cell Formatting?

Cell formatting changes how data looks without changing the actual value.

Example:

Value: 1000

Can be displayed as: ₹1,000 or 1,000.00

The value remains the same; only the appearance changes.

🔤 2. Font Formatting

Path: Home → Font

Common Options:

Feature | Purpose

Bold | Highlight important data

Italic | Add emphasis

Underline | Draw attention

Font Size | Increase/decrease text size

Font Color | Change text color

Shortcuts:

Ctrl + B : Bold

Ctrl + I : Italic

Ctrl + U : Underline

Example:

Before: Total Sales

After Bold: Total Sales

🎨 3. Fill Color (Background Color)

Used to highlight important cells.

Path: Home → Fill Color

Common Usage:

🟢 Completed

🟡 Pending

🔴 Critical Issues

Example Dashboard Colors:

Status | Color

Good | Green

Warning | Yellow

Bad | Red

📦 4. Borders

Borders separate data visually.

Path: Home → Borders

Common Borders:

✅ All Borders

✅ Outside Borders

✅ Thick Borders

Example:

Without Borders: Name Sales Rahul 5000

With Borders: Structured and easier to read.

📏 5. Adjusting Column Width

Sometimes text gets cut off.

Manual Method: Drag column boundary

AutoFit Method: Double-click column boundary

Shortcut Path: Home → Format → AutoFit Column Width

📌 Excel automatically adjusts width to fit content.

📐 6. Adjusting Row Height

Manual Method: Drag row boundary

AutoFit: Home → Format → AutoFit Row Height

Useful when using wrapped text.

📄 7. Wrap Text

Wrap Text displays long text on multiple lines inside the same cell.

Path: Home → Wrap Text

Example:

Without Wrap Text: This is a very long product description may overflow.

With Wrap Text: The content appears on multiple lines within the same cell.

📌 Very useful in reports and dashboards.

🔗 8. Merge & Center

Combines multiple cells into one.

Path: Home → Merge & Center

Example:

Merge A1:D1 to create: Monthly Sales Report

⚠️ Avoid merging cells in raw datasets because it can cause sorting and filtering problems.

🔢 9. Number Formatting

Excel provides different number formats.

Path: Home → Number

Common Formats:

Format | Example

General | 1000

Number | 1,000

Currency | ₹1,000.00

Percentage | 25%

Date | 15-Jun-2026

Time | 10:30 AM

💰 10. Currency Formatting

Shortcut: Ctrl + Shift + $

Example: 25000 becomes ₹25,000.00

Useful for: Financial reports, Budgets, Sales analysis

📊 11. Percentage Formatting

Shortcut: Ctrl + Shift + %

Example: 0.75 becomes 75%

Used for: Growth rates, KPIs, Conversion rates

📅 12. Date Formatting

Excel stores dates as numbers internally.

Common Formats:

15-Jun-2026

15/06/2026

June 15, 2026

Shortcut: Ctrl + Shift + #

🎯 Mini Practice Project

Create: Sales_Report.xlsx

Data:

Product | Sales

Laptop | 50000

Mobile | 30000

Tablet | 20000

Practice:

✅ Bold headers

✅ Apply background color

✅ Add borders

✅ Format sales as currency

✅ AutoFit columns

✅ Merge title row

✅ Wrap long text

🏆 End of Part 3

After completing this lesson, you should be able to:

✅ Format professional-looking reports

✅ Use fonts, colors, and borders

✅ Format numbers, dates, and currency

✅ AutoFit rows and columns

✅ Use Wrap Text and Merge Cells

✅ Improve report readability significantly

➡️ Double Tap ❤️ For Part-4