What you will build

Sort and filter the Weekly study plan records without separating values that belong to the same row, then clear the filter to recover the full dataset.

Learning objectives

Open the practice workbook

HANDS-ON PRACTICE

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.

Make a Google Sheets copy (access required) ↗View original

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.

The complete Weekly study plan source table before filtering.

Hands-on practice

Step 1: Select A1:D5, including the header row, then choose Data > Create a filter.

A1:D5 selected, including the header row, before creating a filter.
The Data menu opened at Create a filter for the selected table.
Filter controls visible on the table header row after creating the filter.

Step 2: Click the filter icon in the Status header. Under Filter by values, leave only Planned selected, then click OK. Only the Wed and Thu rows should remain visible.

Status filtered to Planned so only the Wed and Thu rows remain visible.

Step 3: Choose Data > Remove filter and confirm all four original rows return in their original order.

The Data menu opened at Remove filter after checking the filtered result.
All four original rows restored after removing the filter.

Checkpoint

DaySubjectMinutesStatus
MonMath45Done
TueEnglish30Done
WedScience60Planned
ThuHistory40Planned

Checkpoint for “Sort and filter entries in Weekly study plan”: the Day, Subject, Minutes, 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 Day, Subject, Minutes, 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

  • ✓Filter the full A1:D5 table so values in each record stay on the same row.
  • ✓Select A1:D5 including headers before creating the filter.
  • ✓Use Data > Create a filter, then filter Status to Planned.
  • ✓Verify only Wed and Thu remain while the filter is active.
  • ✓Use Data > Remove filter and confirm all four original rows return.
QUICK CHECK

Check your understanding

Answer four questions about the practice sheet.

1. Which range should you select before creating the filter?
2. Which menu command creates the filter in this lesson?
3. What should remain visible when Status is filtered to Planned?
4. How do you restore the full sample after checking the filter?

Next lesson

Continue in recommended learning order with Fix leading zeros disappearing.