1.4 Formatting Cells
Formatting changes how a cell looks, not its value.
Steps in Excel
- Font, fill, borders: Home › Font group (Bold Ctrl + B, Fill Color, Borders).
- Alignment: Home › Alignment – Wrap Text, Merge & Center, orientation, indent.
- Center Across Selection (better than Merge): select A1:F1 › Ctrl + 1 › Alignment tab › Horizontal › Center Across Selection.
- Cell Styles: Home › Styles › Cell Styles (Heading 1, Good, Bad, Neutral…).
- Format Painter: Home › Clipboard › Format Painter. Double-click it to paint many places; press Esc to stop.
- Clear formats only: Home › Editing › Clear › Clear Formats.
- Column width: double-click the boundary between column headers to AutoFit.
Worked example. Zoya formats the daily report header of the Hadapsar store: row 1 title "FreshGo Hadapsar – Daily Sales" in 14 pt bold, centred across A1:H1; header row 3 with dark green fill, white bold text and a bottom border; amounts right-aligned; AutoFit all columns.
Ravindra Bagale's Tip
Many students use Merge & Center for headings, and then sort, copy-paste and filter give errors. For a title, use Center Across Selection – it looks the same, but the cells are not merged. Never merge cells inside a data table.
Ravindra Bagale's Tip – मराठी
बरेच students heading साठी Merge & Center वापरतात, आणि मग sort, copy-paste आणि filter ला error येतो. Title साठी Center Across Selection वापरा – दिसायला तसंच, पण cells merge होत नाहीत. Data च्या table मध्ये तर merge अजिबात करू नका.
Ravindra Bagale's Tip – हिंदी
बहुत से students heading के लिए Merge & Center लगाते हैं, और फिर sort, copy-paste और filter में error आता है. Title के लिए Center Across Selection इस्तेमाल करो – दिखता वैसा ही है, पर cells merge नहीं होते. Data की table में तो merge बिल्कुल मत करो.
Worked example — formatting cells
Why
Vikram Rao in Pune and Carlos Rivera abroad both need a clear, repeatable way to use formatting cells on a Orbit Logistics sheet without breaking totals.
What
Formatting Cells is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for formatting cells.
- Enter a small made-up value for Vikram Rao using € where money appears.
- Add a second value for Carlos Rivera using € so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once formatting cells is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of formatting cells on a blank sheet for Skyline Clinics.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Rohan Patil and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Emma Clarke.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply formatting cells to a 5-row made-up Skyline Clinics table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with formatting cells.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as SkylineClin_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
