Intermediate Excel · Interactive lesson 11 of 12
Workbook organization & protection
A workbook someone else can open and actually understand needs the same structure every time: clearly named sheets, a frozen header, named ranges instead of bare cell addresses, and formulas protected from an accidental overwrite.
Screens shown: Excel for Microsoft 365 for Windows. Practice works in any browser.
Written tutorialOrganize and Protect an Excel WorkbookSkill check
Try these first:
- Explain what belongs on an Input sheet versus a Summary sheet.
- Freeze the header row (and a left column) on a wide sheet.
- Create and use a named range.
- Protect a sheet's formulas while leaving input cells editable.
All familiar? Skip ahead to I12 — Productivity & Auditing.
Targeted teach
What you're learning
- Clear sheet names
- Input, Data, Summary, Reference — a name that says what lives there, not "Sheet2."
- Freeze Panes
- Pins a header row (and optionally a left column) so it stays visible while the rest of the sheet scrolls.
- Named ranges
- Give a cell or range a plain-English name from the Name Box, then reference it by name in any formula, on any sheet.
- Comments & notes
- A comment threads a conversation about a cell; a note is a static sticky reminder — both keep context out of the formula itself.
- Protect Sheet
- Lock the cells that shouldn't change, leave the input cells unlocked, then protect — only the unlocked cells stay editable.
- Hiding helper sheets
- Fine for scratch calculations nobody else needs to see — but hide sparingly, since a hidden sheet is also an easy one to forget exists.
Where to find it in Excel
Review›Protect Sheet›View › Freeze Panes
| A | B | C | D | E | F | G | ||
|---|---|---|---|---|---|---|---|---|
| 1 | Assumption | Value | Note | |||||
| 2 | Tax rate | 8% | ||||||
| 3 | Growth | 3.5% | ||||||
| 4 | Start month | Jan 2027 | ||||||
| 5 | ||||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
Swipe sideways to see the whole window.
- 1Review tab.
- 2Unlock the input cells first (Format Cells › Protection), then Protect Sheet.
- 3Leave only Select locked/unlocked cells ticked so people can type in inputs but not change formulas.
- 4Name each sheet for its job: Inputs, Calc, Summary. Right-click a tab › Hide for helper sheets.
- 5View › Freeze Panes keeps the header row visible (the line under row 1).
Rendered view of Excel for Microsoft 365 (Windows). Ribbon layout can differ slightly on Mac, Excel for the web or a narrow window.
Guided practice
Click a sheet tab to see what belongs on it, freeze the header on the scrollable table, then look up a named range.
Independent variation
Reorganize a real workbook
Take a workbook you actually use and split it into clearly named sheets — Input, Data, Summary, and Reference if it needs one. Freeze the header row on any sheet with more rows than fit on screen, name at least one range you reference often, and protect the sheet holding your formulas.
Spot a mistake or have an idea for this lesson? Send feedback