3.1 Font Styling, Cell Fill Colors & Custom Borders

Professional fonts (Segoe UI, Aptos, Calibri), background fills (muted/pastel colors), thin vs double bottom accounting borders.

---

Excel 2024 Complete Notes — Chapter 3

Formatting & Professional Worksheet Design

Language: Hinglish | Level: Basic to Advanced

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

1. Chapter Overview

Is chapter mein aap seekhenge:

1. Excel formatting kya hai aur kyun zaroori hai
2. Font, font size, Bold, Italic aur Underline
3. Font Color aur Cell Fill Color
4. Cell Borders
5. Horizontal aur Vertical Alignment
6. Wrap Text aur Merge & Center
7. Row Height aur Column Width
8. Number, Date, Time, Currency aur Percentage formats
9. Format Painter aur Clear Formats
10. Conditional Formatting ka introduction
11. Professional worksheet design ke rules
12. Practical assignments, shortcuts aur exercises ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

2. Excel Formatting Kya Hai?

Formatting ka matlab worksheet ke data ki appearance ko change karna hai, taaki data readable, organised aur professional dikhe.

Example:

• Headings ko bold karna
• Column headings ko background colour dena
• Marks ko percentage format mein dikhana
• Salary ko currency format mein dikhana
• Long text ko Wrap Text se poora dikhana
• Table ke around borders lagana

[!NOTE] Important: Formatting aam taur par cell ki appearance badalti hai, underlying value ko nahi. Lekin kuch operations, jaise number ko text mein convert karna, data type ko bhi affect kar sakte hain.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

3. Home Tab Ke Formatting Tools

Excel mein adhiktar basic formatting tools Home tab par milte hain.

Important groups:

• Clipboard: Cut, Copy, Paste, Format Painter
• Font: Font name, size, Bold, Italic, Underline, Borders, Fill Color, Font Color
• Alignment: Horizontal/Vertical alignment, Orientation, Wrap Text, Merge & Center
• Number: Number Format, Currency, Percentage, Decimal places
• Styles: Conditional Formatting, Format as Table, Cell Styles
• Cells: Insert, Delete, Format
• Editing: AutoSum, Fill, Clear, Sort & Filter, Find & Select Excel version aur window size ke hisaab se tools ka layout thoda alag ho sakta hai.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

4. Font Formatting

Font formatting se text ka style, size aur appearance change hota hai.

A. Font Name

Examples:

• Aptos
• Calibri
• Arial
• Times New Roman Steps:

1. Cell ya range select karein.
2. Home tab open karein.
3. Font dropdown se font choose karein.

B. Font Size

Font size text ka size control karta hai.

Steps:

1. Cells select karein.
2. Home → Font Size.
3. Required size choose karein, jaise 11, 12 ya 14.

C. Bold

Shortcut: Ctrl+B

Text ko bold karta hai. Headings ke liye useful hai.

D. Italic

Shortcut: Ctrl+I

Text ko italic style deta hai.

E. Underline

Shortcut: Ctrl+U

Text ke neeche line lagata hai.

Practical

A1:E1 mein column headings enter karein:

Student ID | Name | Class | Marks | City

A1:E1 select karein:

• Bold apply karein.
• Font size 12 karein.
• Centre alignment apply karein. Expected result: headings data rows se visually distinct dikhengi.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

5. Font Color Aur Fill Color

A. Font Color

Text ka colour change karta hai.

Steps:

1. Cells select karein.
2. Home → Font Color.
3. Colour choose karein.

Example: Heading ka text dark blue.

B. Fill Color

Cell ke background ka colour change karta hai.

Steps:

1. Cells select karein.
2. Home → Fill Color.
3. Background colour choose karein.

Example: Column headings ke liye light blue background.

Best Practice

• Body text ke liye readable contrast rakhein.
• Ek worksheet mein bahut saare random colours use na karein.
• Light background par dark text aam taur par readable hota hai.
• Sirf colour se important meaning convey na karein; labels bhi use karein. ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

6. Cell Borders

Borders cells ke around ya selected edges par lines add karte hain.

Common options:

• Bottom Border
• Top Border
• Left Border
• Right Border
• All Borders
• Outside Borders
• Thick Outside Borders
• No Border

---

Hands-on Practice Exercise

[!TIP] Open Microsoft Excel 365 / 2024 on your computer right now and practice each step described above. Memorize the keyboard shortcuts and try them in a fresh worksheet.

• Complete the practical walkthrough in Excel.
• Verify formatting and formula results.
• Attempt the chapter knowledge quiz when ready.