Theory
From data dump to report
Aryan's imported shop data is correct but ugly: no headings stand out, long product names spill and get cut off, and it is one grey blur of numbers. Meera glances at it and says 'I cannot read this'.
The numbers are fine; the presentation is not. Turning a raw grid into something a busy shop-owner can read in seconds is formatting, and a power user does it in a few quick moves.
The golden rule to hold throughout: formatting changes only how data LOOKS, never what it IS. A bold red number is still the same number.
Theory
Dressing up for the meeting
The same person can show up in pyjamas or a pressed shirt, they are the same person, just presented differently. Formatting is dressing your data for its audience: fonts and colour are the outfit's emphasis, alignment is posture (how it stands in its space), borders are the frame around the photo. None of it changes the person (the value); it changes how seriously the viewer takes them.
At a glance
The three basic formatting tools
| Tool | Controls | Power use |
|---|---|---|
| Font | Typeface, size, bold, colour, fill | Make headers stand out |
| Alignment | Left/center/right, Wrap, Merge | Fit long text, center titles |
| Borders | Lines around/between cells | Structure a printable report |
Theory
The moves that matter
- Font group (Home tab): bold the header row, enlarge the title, colour negatives red, add a light fill to alternate rows. Emphasis creates hierarchy, the eye knows where to look.
- Alignment group: Wrap Text shows a long product name on several lines within one cell instead of spilling; Merge & Center joins cells for a title banner; vertical/horizontal alignment tidies mixed content.
- Borders: draw real lines to separate the header, group totals, box the report. Note: the faint on-screen gridlines are just a guide and do not print by default, borders are what actually appear on paper.
Quiz
Aryan makes a cell holding 1500 bold, red, and larger. What happens to the value 1500?
- Nothing, formatting changes appearance only; it is still the number 1500
- It becomes text because it is now red
- It is rounded to a new value
- It can no longer be used in formulas
Show the answer
Nothing, formatting changes appearance only; it is still the number 1500
Formatting is appearance-only: bold, colour and size change how 1500 looks, never what it is, it stays the number 1500, fully usable in SUM and every formula. This is the same display-versus-value principle from BCA105 number formatting. Believing formatting alters the value (or type) is a classic beginner misconception.
Think first
The Merge trap
Aryan has three cells holding 'Sugar', 'Tea', 'Rice'. He selects all three and clicks Merge & Center to make a banner. What happens to 'Tea' and 'Rice'?
Show the answer
They are discarded. Merge & Center keeps only the top-left cell's value ('Sugar') and throws away the rest, Excel even warns you. Merge is safe for a title banner over empty cells, but merging cells that hold data loses everything except the first. It also breaks clean sorting and selection later. Use Merge sparingly, and never over data you need to keep.
Watch out
Where marks leak
Believing formatting changes the value or data type, it changes appearance only. Confusing Wrap Text (long text on multiple lines inside one cell) with Merge (joining cells). Forgetting Merge keeps only the top-left value (loses the rest). And mixing up borders (drawn lines that print) with gridlines (the faint screen guide that does not print by default). These appearance-vs-value and merge distinctions are standard exam points.
Theory
Format for the reader, then automate it
A good report answers Meera's question before she asks it: bold what matters, box the totals, wrap the long names. But re-doing this on every monthly report is tedious, which is exactly why the next lesson covers Cell Styles and Themes (save a look once, apply with one click) and Format Painter (from BCA105). Format once, reuse forever. First though: saving, navigation and custom number formats.
Summary
Key takeaways
- Formatting turns a raw data dump into a readable report, changing appearance only.
- Font (bold, size, colour, fill) creates emphasis and visual hierarchy.
- Alignment includes Wrap Text (long text on multiple lines in one cell) and Merge & Center (join cells).
- Merge keeps only the top-left value and discards the rest, use it carefully.
- Borders are printable lines that structure a report; gridlines are a screen guide that does not print.
- Memory hook: dressing up the data, same person, better presented.