🧮 Day 53: Formatting Cells (MS Excel) – Hinglish

Formatting Cells (MS Excel) – Hinglish

📌 Cell Formatting kya hota hai?

Excel me cells ka look change karna = Cell Formatting.

👉 Isme hum change karte hain:

  • Font (style, size, color)

  • Alignment (left, center, right)

  • Number format (General, Number, Date, Currency)

  • Border & Fill color

🎨 1) Font Formatting

✅ Steps:

  1. Cell select karo

  2. Home Tab → Font group

👉 Options:

  • Bold (Ctrl + B)

  • Italic (Ctrl + I)

  • Underline (Ctrl + U)

  • Font Size & Color

📏 2) Alignment (Text Position)

👉 Types:

  • Left Align

  • Center Align

  • Right Align

✅ Steps:

Home Tab → Alignment group

👉 Extra options:

  • Wrap Text (text ko next line me lana)

  • Merge & Center (cells merge karna)

🔢 3) Number Formatting

👉 Types:

  • General

  • Number

  • Currency (₹)

  • Percentage (%)

  • Date

  • Time

✅ Steps:

  1. Cells select karo

  2. Home Tab → Number Format drop-down

🖌️ 4) Border & Fill Color

✅ Border:

  • Cell ke around line lagana

Steps:
Home Tab → Borders

✅ Fill Color:

  • Cell background color

Steps:
Home Tab → Fill Color

⚙️ 5) Format Cells Dialog Box

👉 Shortcut Key:

Ctrl + 1

Isme options:

  • Number

  • Alignment

  • Font

  • Border

  • Fill

  • Protection

🧪 Practice Task (Important)

👉 Excel me ye data banao:

NameMarksResult
Rahul80Pass
Priya90Pass
Amit40Fail

Tasks:

  • Header row ko Bold & Center karo

  • Marks column ko Currency / Number format do

  • Fail wale cell ko Red color do

  • Table me border lagao

📝 Short Notes (Exam ke liye)

👉 Cell Formatting = Cells ka design change karna
👉 Ctrl + 1 = Format Cells

⬅ Previous Day


                            Next Day ➡