Summary  
This chapter covers implementing data filtering, enabling conditional display of dataset rows based on text, numeric, and date criteria, and combining multiple column filters using AND/OR logic.

General domain of usage  
Retail sales data analysis

### Turning Filters On and Off
- Click any cell inside the range → **Data tab → Filter**, or press `Ctrl+Shift+L` (Win)/`Control+Shift+L` (Mac). Dropdown arrows appear in every header cell;
- Tables created with `Ctrl+T` have filters enabled automatically in the header row — no manual step needed;
- Click **Filter** again in the ribbon, or press `Ctrl+Shift+L` a second time. The dropdown arrows are removed from the header row.

Filter type depends on data types:
1. **Text filter**: filter by specific values or text conditions;
2. **Number filter**: filter by comparisons such as greater than, less than, or between;
3. **Date filter**: filter by periods — specific dates, months, or years.

### AND / OR Logic Across Multiple Filters

- **OR**: within a single column — a row shows if it matches any selected value;
- **AND**: across different columns — a row must satisfy all active filters to remain visible.

Shortcut turns off all filters at once. Pressing `Ctrl+Shift+L` to turn filters off removes every active filter condition across all columns simultaneously — not just the current column. If you only want to reset one column, use **Clear Filter** from that column's dropdown instead.

Note

Learn Excel the fun way — step by step, you'll go from basic data handling to building charts and dashboards that actually make sense. You'll learn how to organize messy data, use formulas with confidence, and turn numbers into clear insights.


Messy spreadsheets turn into clean, structured data. Tables, sorting, filtering, and smart input rules help keep everything accurate and easy to work with.

Raw data becomes clear and readable. Formatting, alignment, and conditional highlights make important insights stand out instantly.

Numbers start working for you. Formulas, functions, and logical conditions handle calculations, automate tasks, and solve real problems.

Data turns into visuals that tell a story. Charts, sparklines, and design improvements make information easy to understand at a glance.

Big datasets become simple summaries. PivotTables, interactive controls, and dashboards bring everything together into clear, dynamic insights.

Filtering

Turning Filters On and Off

AND / OR Logic Across Multiple Filters