A spreadsheet that looks perfect on screen can still print as a mess: half the columns cut off, a lonely orphan row on page two, or text so tiny nobody can read it. Today you learn page setup so one of your Something Real spreadsheets prints cleanly on a single landscape A4 page, ready to hand to a supervisor, sponsor, or examiner.
Think of the widest spreadsheet in your Specialism portfolio so far (budget, VAT sheet, time tracker, multi-column project data). If you hit print right now with no changes, what would go wrong first: columns chopped off the right edge, rows spilling onto a second page, or text shrinking until it is unreadable?
Three controls do most of the work when a wide sheet must print on one clean page. You will use all three in the step-by-step task.
| Concept | Why it matters | Example |
|---|---|---|
| Orientation — portrait (tall) or landscape (wide) page direction | Wide project tables almost always need landscape; forcing portrait chops columns or shrinks text | A Work Experience hours sheet with Date, Start, End, Break, Hours, Rate, Pay, Notes fits landscape; portrait cuts Notes off the page |
| Margins — the blank border around the printed edge (Normal, Narrow, Wide, or custom) | Narrow margins buy horizontal space for extra columns without making body text microscopic | Switching a GAA club fixture table from Normal to Narrow margins often pulls the last column back onto page one |
| Scale to fit — shrinks content so it fits a set number of pages wide and/or tall | Fit to 1 page wide is the usual fix for wide sheets; over-scaling makes numbers unreadable, so always check preview | A side-hustle cost sheet with nine columns: Fit to 1 page wide + landscape keeps every euro visible on one A4 page |
Two quick checks your teacher will also flag in the live demo: set paper size to A4 (the standard size across Irish schools, businesses, and official printing — many browser templates still default to US Letter), and always judge the result in print preview before you commit paper or a PDF.
You will open a wide practice sheet (Item, Supplier, Net €, VAT €, Gross €, Qty, Line total, Status, Notes) so print preview shows one landscape A4 page with narrow margins and scale-to-fit width. That is the same quality bar you will apply to your own Something Real spreadsheet.
Open the wide practice spreadsheet (your teacher will share a starter file with headings and sample rows already filled), watch default portrait print preview fail, then fix orientation, A4 paper size, margins, and scale until one clean landscape page appears. Your teacher will demonstrate the first pass on the classroom screen; then follow the steps for your platform.
Stop when {{menu:File -> Print}} shows one landscape A4 page with all nine headings readable. Do not start shrinking scale until landscape, A4, and narrow margins are set.
| Issue | Solution |
|---|---|
| Print preview still shows columns cut off after I chose landscape | Check paper size is A4 (not Letter), set margins to Narrow, then use Fit to width / 1 page wide. Re-open print preview after each change. |
| Everything fits on one page but the numbers are too small to read | You over-scaled. Prefer landscape + narrow margins first. Hide or move non-essential columns, or print only the key range, before dropping scale below about 80%. |
| A mostly blank second page appears with one row or a footer | On taller project sheets, set height scaling to 1 page (or Fit to page), or slightly reduce row heights. Check there are no stray values far to the right or below your real table ({{kbd:Ctrl+End}} / {{kbd:Cmd+End}} finds the true used range). |
| My print settings look different from the instructions | Excel in the browser and Google Sheets both put orientation, A4, margins, and scale mainly inside {{menu:File -> Print}}. Match your app's print pane, not your neighbour's screen. Layout can vary slightly by browser or account, but the same four controls are there. |
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.