Cell Formatting
Formatting changes how data looks in a cell, without changing the actual value. Good formatting makes a spreadsheet easy to read and understand at a glance.
🎨 Before and After Formatting
Before
| Item | Price |
| Pencil | 5 |
➡️
After
| Item | Price |
| Pencil | ₹5.00 |
Common Formatting Options
- Bold / Italic – Makes text stand out
- Fill Colour – Adds background colour to a cell
- Font Colour – Changes the colour of the text
- Borders – Adds lines around cells
- Number Format – Shows numbers as currency, percentage, or date
Number Formats
| Format | Raw Value | Shown As |
|---|---|---|
| Currency | 50 | ₹50.00 |
| Percentage | 0.5 | 50% |
| Date | 45000 | 15-Mar-2026 |
How to Apply Formatting
- Select the cell or cells you want to format
- Go to the Home tab
- Click the formatting button you need, such as Fill Colour or Bold
- The change appears in the selected cells right away
🔑 Key Terms
- Formatting – Changing the look of data without changing its value
- Fill Colour – Background colour applied inside a cell
- Number Format – A style that controls how a number is displayed
✏️ Exercise
- Does formatting change the actual value in a cell?
- Which format shows 0.5 as 50%?
- Which tab holds the formatting buttons?
© estudy247.com | Junior Computer Skills – Class 5