⬇ Download PDF

Unit 2 · Topic 05 · Data Analysis and Representation (Google Sheets)

Formatting the Table - color, font style, font size, border, alignment

Hook

Anaya's Diwali stall table was finished.

Every number in it was correct.

Ms. Rao looked at it for ten seconds and asked one question: "Which row is the heading?"

Nobody in the lab could tell.

The Story

Class 4 had run a sweet stall before Diwali. Anaya typed it all into Google Sheets, fast as always. Ladoo, Barfi, Jalebi. Boxes sold. Price per box. Not one number was wrong.

But the sheet looked like grey soup. Same font, same size, same colour, no lines anywhere. Kabir squinted at it. "Wait — is Ladoo a heading or a sweet?"

"It's a sweet. Obviously," said Anaya.

"Not obviously," groaned Pixel, the lab's oldest desktop.

Ms. Rao came over. "Your data is perfect. Your table is unreadable. Fix the look, not the numbers."

Anaya went for the toolbar. She selected row 1 and clicked B for bold. She clicked the paint bucket and filled the header row blue. The heading jumped out at once.

Then she got excited. She selected the whole table, set the font size to 24, coloured every word red and made it all bold. The sheet now looked like a fire alarm. Half the numbers spilled past their columns.

"Kabir?" said Ms. Rao.

"It's… shouting," said Kabir carefully.

So Anaya undid it. She kept the header bold and blue. She put the data back to font size 11 and plain black. She used the borders button to draw a thin line around every cell. Last, she right-aligned the number columns, so the digits lined up instead of hugging the left edge.

Now it looked like a table. Ms. Rao read it from across the room. "Ladoo, twelve boxes. Barfi, nine. Jalebi, fifteen."

Anaya grinned. She had not changed a single number.

Anaya's finished sweet-stall sheet, showing the bold blue header row, borders around every cell and right-aligned numbers, with three numbered callouts. Anaya's sheet after formatting #ABC SweetBoxesPrice ₹ 1 2Ladoo1240 3Barfi950 4Jalebi1535 123 Header row: bold + blue fill colour Thin borders around every cell Numbers right-aligned, digits line up Anaya changed the look of 12 cells. She changed the value of none of them.
Exactly what Anaya's sheet looked like once she stopped shouting.

So What Just Happened?

Formatting changes how a table looks, never what it means. The value 12 is still 12 whether it is red, huge or bold.

The Google Sheets toolbar holds every tool Anaya used. The paint bucket is fill colour, for a cell's background. The letter A with a colour bar under it is text colour. The B, I and U buttons make text bold, italic or underlined. Beside them sit the font box and the font size box. The borders button draws lines around cells, and the alignment buttons push text left, centre or right. The Format menu, under Text and Alignment, does the same jobs.

Good formatting has one job: helping the eye find things fast. Too much colour does the opposite.

A comparison of three versions of the same table: plain and unreadable, over-formatted in giant red bold text, and well formatted with one clear header. TOO PLAIN ✗ TOO MUCH ✗ JUST RIGHT ✓ SweetBoxes Ladoo12 Barfi9 Jalebi15 No header stands out. Your eye has nothing to hold on to. Sweet Boxes Ladoo 12 Barfi 9 Jalebi 15 Everything shouts, so nothing stands out. Text spills past the columns. SweetBoxes Ladoo12 Barfi9 Jalebi15 One clear header, borders, numbers lined up right. Same nine values in all three.
Formatting is not decoration — it is a signpost for the reader's eye.

Remember This

  • Formatting changes the look of cells, never the value inside them.
  • The paint bucket fills a cell's background; the A with a colour bar changes text colour.
  • Make the header row different — bold plus one fill colour is enough.
  • Borders separate cells; alignment decides whether text sits left, centre or right.
  • Too many colours and sizes make a table harder to read, not easier.
A cheat card of the Google Sheets formatting toolbar buttons: fill colour, text colour, bold italic underline, font, font size, borders and alignment, with a do and don't pair. Toolbar cheat card — the seven buttons you need bucket A B I U Arial ▾ 11 ▾ Fill colourText colourBold / Italic FontFont sizeBordersAlignment DO — header bold + one fill colour, borders on, numbers right-aligned DON'T — size 24, all red, all bold, six fill colours, nothing lined up
Glance at this the night before the test.

Try It Yourself

Open a blank Google Sheet. Type three friends' names in column A and their cricket scores in column B.

Make row 1 a proper header: bold it, fill it with one light colour, and add borders around all the cells.

Now right-align column B, then ask someone to read your table out loud.

Word Bank

Fill colour
The background colour of a cell — the paint bucket button.
Font size
How big the text is, measured in points, like 11 or 24.
Border
A line drawn around or between cells.
Alignment
Where text sits in a cell: left, centre or right.
Header row
The top row that names each column.

Questions

Loading questions…