Intermediate
60 mins
Teacher/Student led
+80 XP
Pupils work on their own device

Print Preview, Print Areas and Page Setup

Prepare your budget spreadsheet for professional printing by using print preview, setting a print selection, adjusting page layout options and exporting a clean one-page PDF while preserving the original editable file.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • make your budget fit on one landscape A4 page
    • save it as a PDF
    • keep the PDF beside your spreadsheet in {{code:05_budget}}

    First, open {{code:05_project_budget}} in your {{code:05_budget}} folder. If it is missing, make it now. Type these headings in row 1, then add five of your own project costs below them.

    Item | Category | Cost | Notes

    Warm-up

    If you printed your budget right now, what would go wrong first?

    2 - Key Concepts ~6 mins

    Print Preview shows how your sheet will look on paper before you print it or save it.

    A print area is the part of the sheet you choose to print. You select your budget block, then choose Print selection in Excel or Selected cells in Google Sheets.

    Page setup covers the paper size and which way the page turns. Budgets are wide, so use A4 landscape.

    Example

    If the Notes column is cut off in the preview, fix your selection before you save the PDF.

    3 - Step-by-step Task ~15 mins

    You will get your budget ready to print on one page. Watch your teacher first, then follow the steps in the box below on your own {{code:05_project_budget}}.

    Stop when the preview looks good. You will save the PDF in the next task.

    4 - Common Issues ~4 mins

    Common issues

    • You get extra pages that are nearly empty. Select only your budget block, then choose Print selection or Selected cells.
    • The text is too small to read. Hide helper columns, select less, and preview again.
    • Your costs show as ####. Make the Cost column a little wider, then preview again.
    • You only have a screenshot. Go back to {{menu:File -> Print}} and choose Save as PDF.

    5 - Independent Practice ~20 mins

    Independent Practice

    Your goal: Save your budget as a one-page landscape A4 PDF, and keep the spreadsheet as well. This counts for your Key Assignment.
    Time: ~20 minutes
    Task:
    1. Open {{code:05_project_budget}} in your {{code:05_budget}} folder.
    2. Hide any helper columns, then select only your budget block.
    3. Open {{menu:File -> Print}}. Choose Print selection or Selected cells, then A4 and Landscape.
    4. Check the preview. If you have to zoom to read the costs, fix your selection and try again.
    5. Save it as {{code:05_project_budget.pdf}}, then upload it into {{code:05_budget}}.

    If you get stuck, look back at the Step-by-step task.

    Success criteria:
    • My whole budget fits on one landscape A4 page.
    • I can read the costs without zooming.
    • {{code:05_project_budget}} and {{code:05_project_budget.pdf}} are both in {{code:05_budget}}.
    123learn · Online learning platform

    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.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more