What you will build
Freeze the header row so the Task, Owner, and Status columns remain identifiable while you scroll the practice table.
Learning objectives
Open the practice workbook
Practice in your own copy
Make your own Google Sheets copy with the same data, formulas, formatting, filter and frozen header. The original remains unchanged.
Sign in to Google. If the original is not publicly shared, download the full workbook and import it into Google Sheets, or paste the example data into your own sheet.
Hands-on practice
Step 1: Choose View > Freeze > 1 row.
Step 2: Scroll down far enough that the original row 1 would normally leave the viewport; confirm the Task, Owner, Status header remains visible.
Step 3: Return to the top and confirm the four source records are unchanged.
Checkpoint
| Task | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
| Launch | Vy | Planned |
Checkpoint for “Fix frozen row problems”: keep the Task, Owner, Status source records intact after the lesson action.
Common mistakes and fixes
Correction: use the visible View > Freeze menu, then compare the scrolled sheet with the Task, Owner, Status header and the four source records.
Independent practice
Add one row with the same schema, repeat the action, verify the new row behaves correctly, then remove it to restore the sample.
Key takeaways
- ✓Freeze the header row so the Task, Owner, and Status columns remain identifiable while you scroll the practice table.
- ✓Use View > Freeze > 1 row to keep the first row visible.
- ✓Scroll down and confirm the Task, Owner, Status header remains visible.
- ✓If the wrong number of rows is frozen, reset with View > Freeze > No rows, then choose 1 row.
- ✓Return to the top and confirm all four source records remain unchanged.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with the next lesson in the path.
Comments
No comments yet. Be the first to join the discussion.