What you will build
Complete “Hide and unhide rows and columns” using the visible Item, Internal ID, Status sample so each action and the final state can be checked against the source data.
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: Click the B column header to select the entire Internal ID column.
Step 2: Right-click the B column header and choose Hide column. Verify column B disappears and the hidden-column arrows appear between columns A and C.
Step 3: Confirm Item and Status remain aligned on each row while Internal ID is hidden; hiding a column must not delete its values.
Step 4: Click the hidden-column arrow between A and C to unhide column B, then verify Internal ID and SKU-001, SKU-002, SKU-003 return unchanged.
Checkpoint
| Item | Internal ID | Status |
|---|---|---|
| Pen | SKU-001 | Active |
| Notebook | SKU-002 | Active |
| Folder | SKU-003 | Inactive |
Checkpoint for “Hide and unhide rows and columns”: the Item, Internal ID, Status columns and sample records must still match this table after the lesson action.
Common mistakes and fixes
Correction: return to the exact range and command named in the steps, then compare the live sheet with the Item, Internal ID, Status source fields.
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
- ✓Select a full column from its letter header.
- ✓Use the column context menu > Hide column.
- ✓Look for hidden-column arrows between neighboring columns.
- ✓Hiding does not delete cell values.
- ✓Click the hidden-column arrow to unhide the column and verify the values return.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Use named functions safely.