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

Multiple Worksheets: Copying, Moving, Deleting, Renaming

You will learn to rename, colour-code, copy, move and delete sheets in a workbook. Then restructure your Something Real project into three named sheets for data, summaries and charts so readers can navigate easily.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • rename, colour, copy, move and delete sheet tabs
    • practise on a small workbook for Jamie's side hustle
    • split your Something Real workbook into three sheets called data, summary and charts

    Warm-up

    Open {{code:Project_Portfolio}}, then {{code:09_specialism}}, then {{code:sm3}}, and find {{code:sm3_from_template}}. Imagine someone has only thirty seconds to find an answer on your sheet. Would they know where to look first?

    2 - Key Concepts ~6 mins

    A sheet is one tab at the bottom of a workbook.

    Rename and colour each tab so people can see what it holds before they click it.

    Copy, move and delete let you make a trial copy, put the tabs in order and remove extras.

    Split or keep one table? A simple list can stay on one sheet. Split it when different readers need different things.

    Example: Jamie's side hustle

    • data holds the product, unit cost, quantity and line total.
    • summary holds the answers.
    • charts stays empty for now.

    3 - Step-by-step Task ~15 mins

    You will practise on a small workbook for Jamie's custom-print side hustle. Copy the table below, then follow the steps in the box below.

    ProductUnit cost (€)QuantityLine total (€)
    Hoodie print12.5020250.00
    Tote bag print4.0035140.00
    Sticker pack1.20100120.00

    4 - Common Issues ~4 mins

    Common issues

    • I renamed the file, not the sheet. Sheet names are on the tabs at the bottom, so double-click a tab instead.
    • I can't find the tab colour. Right-click the tab itself, not a cell.
    • Do I need to move all my rows to a new sheet? No. Just rename the sheet that already holds them to data.

    5 - Independent Practice ~20 mins

    Independent Practice

    Your goal: Split your Something Real workbook into three sheets called data, summary and charts.
    Time: ~20 minutes
    Task:
    1. In {{code:sm3}}, find {{code:sm3_from_template}}. If you don't have it, make it and paste in Jamie's table.
    2. Right-click it and choose {{btn:Duplicate}} (OneDrive) or {{btn:Make a copy}} (Google Drive). Rename the copy {{code:sm3_from_template_one_sheet}}.
    3. Open {{code:sm3_from_template}}, not the copy. Rename the sheet with your rows to {{code:data}} and colour it blue.
    4. Add {{code:summary}} in green and {{code:charts}} in purple. Put the tabs in order and delete any extras.
    5. On {{code:summary}}, type two or three answer labels, such as Hours this month. Leave {{code:charts}} blank.
    Success criteria:
    • I have three sheets: data, summary and charts.
    • The tabs are coloured and in that order.
    • My summary sheet has clear answer labels.
    • My one-sheet copy is saved in {{code:sm3}}.
    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 - 2026. 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