1 - Introduction ~5 mins
Welcome
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 an examiner who has to understand your sheet without you sitting beside them.
By the end of this lesson, you will be able to:
- Highlight answer cells so a reader knows where to look
- Hide and unhide rows or columns used for intermediate calculations
- Clear formatting without deleting the underlying data
- Use ribbon or full-screen view control when you need more sheet space
Warm-up
Think of one spreadsheet you have already made and saved in your own work folder, {{code:Project_Portfolio}} — a VAT calculation, a time tracker, or a workbook with several sheets. If a stranger opened it tomorrow, would they know which cells hold the final answers, and which cells are just working maths on the way to those answers?
2 - Key Concepts ~6 mins
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 three-row product sheet for a student selling stickers, phone cases, and lanyards, which you set up from a short table. Column D holds VAT amounts (intermediate — you will hide it). Column E 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.
3 - Step-by-step Task ~18 mins
Make a short pricing sheet from the practice table below and add three formulas for VAT, Gross and the TOTAL. Then 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.
Practice table (select the whole table, copy it, click cell A1 in your new sheet and paste):
| Product | Net (€) | VAT rate | VAT amount (€) | Gross (€) |
|---|---|---|---|---|
| Sticker pack | 4.00 | 0.23 | ||
| Phone case | 12.50 | 0.23 | ||
| Lanyard | 3.20 | 0.23 | ||
| TOTAL |
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.
4 - Common Issues ~3 mins
Common Issues
| 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. |
5 - Independent Practice ~18 mins
Independent Practice
- A reader can spot the final answers in under five seconds because those cells use a calm highlight colour
- At least one intermediate calculation row or column is hidden, and changing an input still updates the answers
- No random trial colours or leftover styling remain on working areas; only deliberate formatting is left
- The updated spreadsheet is saved in {{code:09_specialism/sm3/}} under its existing name with all data and formulas intact
- The sheet stays in {{code:09_specialism/sm3/}} under that same name, because it is one of the finished pieces of work you will be marked on later — do not rename it
Unlock the full learning experience
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.
This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.