You receive a sales file with hundreds of rows. Your manager asks: “Show me only West region pending orders, and also tell me the highest sales order.” Without Sort and Filter, this takes time. With Sort and Filter, it takes seconds.

Sort vs Filter

Sorting changes the order of rows. For example, highest sales to lowest sales, oldest date to newest date, or customer name A to Z.

Filtering hides rows that do not match your condition. For example, show only West region or only Pending orders.

Simple rule: Sort changes order. Filter controls visibility.

Filtered sales data example

Sales Data — Region Filter: West
Region ▼Product ▼Sales ▼Status ▼
WestLaptop Stand₹2,250Closed
NorthWireless Mouse₹5,200Pending
WestUSB Hub₹3,000Pending

How to sort data

  1. Click anywhere inside the data table.
  2. Open the filter dropdown or go to Data tab.
  3. Choose Sort A to Z, Z to A, Smallest to Largest, or Largest to Smallest.
  4. Check whether all columns moved together correctly.
A-ZAscending sort
Z-ADescending sort
₹Highest to lowest

How to filter data

  1. Click the filter dropdown in the header.
  2. Uncheck Select All.
  3. Select the value you want to see.
  4. Click OK.
  5. Clear the filter when you want all records back.
Single filterShow only Region = West.
Multiple filtersShow Region = West and Status = Pending.
Clear filterBring all hidden rows back.
Search filterFind a category quickly in a long list.
💡
Professional habit: Before sending a file, check whether any filters are still active. Hidden rows can confuse other users.
⚠️
Common mistake: Sorting only one column instead of the full data range. This can break the relationship between columns.
🧪 Practice Lab

Sort and filter a sales dataset

Download one ZIP file containing the practice workbook, challenge workbook, solution workbook, cheat sheet, quiz and answer key.

📦 Download Lesson 13 ResourcesWorks as a standalone file and after website deployment

Mini assignment

  1. Sort sales from highest to lowest.
  2. Filter only West region.
  3. Filter only Pending orders.
  4. Apply two filters together: Region = West and Status = Pending.
  5. Clear all filters and confirm all rows are visible again.

Quick quiz

  1. What does sorting do?
  2. What does filtering do?
  3. Why is sorting only one column risky?
  4. How do you bring filtered records back?

Answers: Changes row order; hides non-matching rows; can misalign data; clear the filter.

FAQ

No. Filtering only hides non-matching rows. The data is still there.
Excel Tables keep the data range structured and automatically provide filter dropdowns.