What you will build
Complete “Insert and delete cells safely” using the visible Item, Owner, 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: Select A2, the Brief cell.
Step 2: Right-click A2, choose Insert cells > Insert cells and shift right. Verify A2 becomes blank while Brief, Linh, and Done shift right together on row 2.
Step 3: With A2 still selected, right-click it, choose Delete cells > Delete cells and shift left. Verify Brief, Linh, and Done return to A2:C2.
Step 4: Confirm the full A1:C5 table matches the checkpoint again before finishing.
Checkpoint
| Item | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
| Launch | Vy | Planned |
Checkpoint for “Insert and delete cells safely”: the Item, Owner, Status columns and sample records must still match this table after the lesson action.
Common mistakes and fixes
Correction: return to the exact cell or range named in the step, recheck the source data, and repeat the specified command; do not type the expected result manually.
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 A2 before using cell-level insert/delete commands.
- ✓Use Insert cells > Insert cells and shift right.
- ✓Use Delete cells > Delete cells and shift left to restore the row.
- ✓Do not use Delete row or Delete column.
- ✓Finish only after A1:C5 matches the checkpoint again.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Resize and auto-fit columns.