Formatting in Excel
Excel mein data ko professional, clean aur easy-to-read banane ke liye formatting ka use kaise karein.
🎨 Formatting Kya Hai?
Hindi: Excel mein data ka font, size, color, alignment, border aur background change karna Formatting kehlata hai.
English: Formatting means changing the appearance of data to make an Excel sheet clear, attractive and professional.
🔤 Font Formatting
Excel mein text ka font change kiya ja sakta hai.
Common Font Options:
• Font Name
• Font Size
• Bold
• Italic
• Underline
Department → Italic
Employee ID → Underline
🖍️ Font Color
Kisi text ko highlight karne ke liye Font Color ka use kiya jata hai.
Department
Salary
Important headings ke liye different font colors use kiye ja sakte hain.
🟦 Cell Fill Color
Excel cell ke background mein color lagane ke liye Fill Color ka use hota hai.
Example: Table ke heading cells ko highlight karna.
▦ Borders
Table ke data ko clearly separate karne ke liye Borders ka use kiya jata hai.
101 Rahul Sales
102 Amit IT
103 Priya HR
Borders se table zyada clean aur professional dikhta hai.
↔️ Alignment
Cell ke andar data ki position change karne ke liye Alignment ka use hota hai.
Common Alignment:
• Left Align
• Center Align
• Right Align
Employee ID → Center
Salary → Right
🔢 Number Formatting
Numbers ko different formats mein display karne ke liye Number Formatting ka use hota hai.
1000.50
25%
Number ko Number, Percentage, Currency ya Decimal format mein show kiya ja sakta hai.
💰 Currency Formatting
Salary, price aur sales amount ke liye Currency format useful hota hai.
₹25,000
₹35,500
₹42,000
📅 Date Formatting
Excel mein dates ko different formats mein display kiya ja sakta hai.
01-Jan-2026
January 01, 2026
📏 Row Height & Column Width
Data ko properly display karne ke liye Row Height aur Column Width ko adjust kiya ja sakta hai.
Rahul Sales ₹25,000
Agar text cut ho raha hai to column width increase kar sakte hain.
📊 Practical Employee Data
Ek professional employee table kuch is tarah ho sakti hai:
101 | Rahul | Sales | ₹25,000
102 | Amit | IT | ₹35,000
103 | Priya | HR | ₹30,000
Heading ko Bold, background color aur border dene se table professional dikhegi.
💼 Professional Formatting
Business aur office Excel files mein formatting bahut important hoti hai.
Ek professional sheet mein:
✅ Clear headings
✅ Proper column width
✅ Consistent font
✅ Proper borders
✅ Correct number format
✅ Clean alignment
⚠️ Important Note
Formatting ka main purpose data ko clear, readable aur professional banana hai.
🎓 Lesson Summary
Is lesson mein humne seekha:
✅ Formatting
✅ Font Formatting
✅ Font Color
✅ Fill Color
✅ Borders
✅ Alignment
✅ Number Formatting
✅ Currency Formatting
✅ Date Formatting
✅ Row Height & Column Width
✅ Professional Excel Formatting