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.
    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 123Learn.ie 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