Ravindra BagaleCourses & study guides

6. Tables, Sorting and Filtering

6.5 AutoFilter

By Last updated:

Steps in Excel

  1. Click in the data › Data › Sort & Filter › Filter (Ctrl + Shift + L). Tables have filter buttons already.
  2. Click the ▾ on City › untick (Select All) › tick Pune and Nashik › OK.
  3. Text Filters › Contains… Road (College Road, Gangapur Road, Hotgi Road).
  4. Number Filters › Top 10… (e.g. Top 5 Items by Amount), Above Average, Between.
  5. Date Filters › This Month, Last Week, Between, or group by year/month in the list.
  6. Filter by selected cell's value: right-click a cell › Filter › Filter by Selected Cell's Value.
  7. Clear: Data › Sort & Filter › Clear; re-apply after data changes with Reapply.

Worked example. Zoya filters: Platform = Blinkit, City = Nagpur, Delivery Mins > 15 → she copies the visible rows (Home › Find & Select › Go To Special › Visible cells only, or Alt + ;) and pastes them into an e-mail to the Sitabuldi store team.

Ravindra Bagale's Tip

Filter kelelya data var copy-paste kelyavar kadhi kadhi lapleli rows pan jaatat (especially grouped/hidden rows) – khup students la he kalat nahi. Copy karaychya aadhi Alt + ; (visible cells only) daba. Ani filter lavun ek column delete karu naka – lapleli rows pan affect hotat.

Practice task

Show only Amazon Now orders above ₹200 from last week. Then show orders whose Area contains "Road". Copy only visible cells to a new sheet.