Lesson 11 – Working With Multiple Sheets

MS Excel Course • Level 2 – Lesson 11

Excel workbooks often contain multiple sheets for organizing data. In this lesson, you will learn how to add, rename, move, copy, hide, and link sheets.

What you will learn

• Add & rename sheets
• Move or copy sheets
• Hide & unhide sheets
• Group sheets
• Refer to another sheet in formulas

1. Adding & Renaming Sheets

• Click + beside sheet tabs to add
• Double-click sheet name to rename

2. Moving & Copying Sheets

• Drag sheet tab → move position
• Right-click → Move or Copy
• Check “Create a copy” to duplicate

3. Hiding Sheets

• Right-click sheet → Hide
• Unhide → Right-click any sheet → Unhide

4. Grouping Sheets

Useful when you want to make the same change across many sheets.

• Hold Ctrl → click sheet tabs
• Sheets get grouped
• Ungroup → Right-click → Ungroup Sheets

5. Referencing Another Sheet in Formulas

Use the format: =SheetName!Cell

Example:

=Sales!B2

Use multiple sheets to separate raw data, analysis, and reports.

Practice Task

• Add 3 sheets: Data, Summary, Report
• Rename, move, and copy sheets
• Hide one sheet and unhide it
• Link a cell: =Data!A1

Homework

• Create 12 sheets named Jan–Dec and group-format the headers