What you will build
Complete “Merge cells without losing data” using the visible Quarterly review, , 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: Confirm A1 contains Quarterly review and rows 2:4 are the Metric, Owner, Value table.
Step 2: Select only A1:C1; do not include the data rows.
Step 3: Choose Format > Merge cells > Merge all.
Step 4: Verify Quarterly review spans A1:C1 while the body data stays in separate cells.
Checkpoint
| Quarterly review | ||
|---|---|---|
| Metric | Owner | Value |
| Revenue | Linh | 320 |
| Orders | Minh | 18 |
Checkpoint for “Merge cells without losing data”: the Quarterly review, , 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 Quarterly review, , 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
- ✓Step 1: Confirm A1 contains Quarterly review and rows 2:4 are the Metric, Owner, Value table.
- ✓Step 2: Select only A1:C1; do not include the data rows.
- ✓Step 3: Choose Format > Merge cells > Merge all.
- ✓Step 4: Verify Quarterly review spans A1:C1 while the body data stays in separate cells.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Apply alternating colors to tables.