What you will build
Complete “Wrap text and align cells” using the visible Task, Long description, 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 A1:C4 so the formatting applies only to the practice table.
Step 2: Choose Format > Wrapping > Wrap so long descriptions stay inside their cells instead of being clipped or overflowing into neighboring columns.
Step 3: Select A1:C1, choose Format > Alignment > Center, and center the three header labels.
Step 4: Verify the long descriptions are fully visible on multiple lines, the header row is centered, and every source value still matches the checkpoint.
Checkpoint
| Task | Long description | Status |
|---|---|---|
| Brief | Confirm scope with the project owner before editing | Done |
| Dataset | Prepare a clean source table for the exercise | Working |
| QA | Verify every visible result before sharing | Planned |
Checkpoint for “Wrap text and align cells”: the Task, Long description, 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 Task, Long description, 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 only the table you want to format.
- ✓Use Format > Wrapping > Wrap for long text.
- ✓Use Format > Alignment > Center for the header row.
- ✓Verify wrapping changes layout, not cell values.
- ✓Keep the full source table readable and unchanged.
Check your understanding
Answer four questions about the practice sheet.
Next lesson
Continue in recommended learning order with Merge cells without losing data.