What you will build
Complete “Move and copy rows and columns” 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: Click row number 2 to select the entire Brief | Linh | Done row. Right-click the row, choose Copy, click row 6, and paste. Verify Brief, Linh, and Done stay together in the copied row, then Undo.
Step 2: Click the B column header to select the entire Owner column. Right-click, choose Copy, click D1, and paste. Verify Owner, Linh, Minh, An, and Vy appear together in column D, then Undo.
Step 3: Click row number 2 again. Right-click, choose Cut, click row 6, and paste. Verify the whole Brief | Linh | Done row moves together instead of splitting across columns.
Step 4: Undo the move and confirm the original Item | Owner | Status table is restored with Brief back on row 2.
Checkpoint
| Item | Owner | Status |
|---|---|---|
| Brief | Linh | Done |
| Dataset | Minh | Working |
| QA | An | Planned |
| Launch | Vy | Planned |
Checkpoint for “Move and copy rows and columns”: 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 a row from its row number before copying or moving it.
- ✓Use Copy to duplicate the whole row, then Undo after verification.
- ✓Select a column from its column letter before copying the whole column.
- ✓Use Cut and Paste to move the whole row while keeping its cells together.
- ✓Undo the practice changes so the original table is restored.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Insert and delete cells safely.