A spreadsheet can hold a lot of working maths that the reader never needs to see. Today you learn three presentation habits that make a sheet feel finished: highlight the answer cells, hide intermediate calculation rows or columns, and clear messy formatting without wiping the numbers. These habits matter when you hand a budget, a VAT sheet, or a Work Experience tracker to a supervisor, a teacher, or a VET examiner.
Think of one spreadsheet already in your {{code:Project_Portfolio}} (VAT calc, time tracker, or multi-sheet workbook). If a stranger opened it tomorrow, would they know which cells hold the final answers, and which cells are just working maths?
Three presentation habits turn a working spreadsheet into something a supervisor can scan in ten seconds. A fourth habit frees screen space while you check a long range.
| Concept | Why it matters | Example |
|---|---|---|
| Answer-cell highlight — a fill colour on the cells that hold the final results a reader came for | Supervisors and examiners skim; colour tells them where to look without reading every formula | Pale green on the Gross (€) column of a side-hustle VAT sheet so the take-home total stands out |
| Hidden rows or columns — intermediate calculations kept in the sheet but not shown on screen or in print | Keeps the working maths available for you, while the reader only sees clean inputs and answers | Hide the VAT amount column after the Gross formula is working; unhide it later if you need to debug. The same right-click Hide works on a row header for a scratch calc row. |
| Clear formatting — strip fill, bold, borders, and number formats while leaving the values and formulas untouched | Lets you reset a messy trial layout without retyping data or rebuilding formulas | Clear neon trial colours from a draft Work Experience hours sheet before applying one calm highlight scheme |
| Toolbar and ribbon control — collapsing or expanding the top menu strip (or using full screen) so you can see more of the sheet | Gives you screen space when checking a long range, then brings the tools back when you need them | Collapse the ribbon (or use full screen) while checking a long Work Experience hours list, then expand it again to use Fill Color |
Worked example you will polish next: a starter three-row product sheet for a student selling stickers, phone cases, and lanyards. Column D already holds VAT amounts (intermediate — you will hide it). Column E already holds Gross totals (answers — you will highlight them). You will also hide a scratch trial row and clear messy trial colours without deleting the numbers.
Open the starter pricing sheet (products, VAT, Gross, and TOTAL formulas already built). Highlight the answer cells, hide the intermediate VAT column, hide a scratch trial row, then clear messy trial formatting without losing any numbers. Your teacher will demo the first highlight, hide, and Clear Formats on the classroom screen; then follow the steps for your platform.
Note on numbers: some Gross values look like 15.375 or 24.231. That is fine for this lesson — we are not currency-formatting yet.
| Issue | Solution |
|---|---|
| I hid a column and now a formula shows {{code:#REF!}} | Hide is not the problem — something was deleted. Use Undo ({{kbd:Ctrl+Z}} / {{kbd:Cmd+Z}}). Hide only removes the column from view; delete removes it from the sheet and breaks references. |
| I cannot find the hidden column or row to unhide it | Select the columns or rows on both sides of the gap (for example C and E if D is hidden, or rows 6 and 8 if row 7 is hidden), then right-click and choose Unhide. In Google Sheets you can also click the small arrows in the header gap. |
| Clear Formats wiped my numbers | You likely chose Clear All or Delete instead of Clear Formats. Undo immediately. Clear Formats only removes styling; values and formulas stay. |
| My whole sheet is one bright colour and looks worse | Select only the answer range before using Fill Color. One calm highlight on the result cells is enough. Use Clear Formats on the noisy areas and start again with a smaller selection. |
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.