---
title: "How are pivot tables used to filter data in excel?"  
description: "How are pivot tables used to filter data in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96521/how-are-pivot-tables-used-to-filter-data-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 1 minute  

---

# How are pivot tables used to filter data in excel?

How are [pivot](https://www.mindstick.com/articles/1511/pivot-with-dynamic-columns-in-sql-server) [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development) used to [filter](https://www.mindstick.com/forum/1176/filter-in-a-xml-file-in-c-sharp) [data in excel](https://answers.mindstick.com/qa/96531/is-it-possible-to-make-pivot-table-using-multiple-sources-of-data-in-excel)?

## Answers

### Answer by Hitesh Vohra

- **Using a slicer, filter [data](https://www.mindstick.com/articles/23186/how-becoming-a-data-analyst-can-be-a-lucrative-career) in a PivotTable.**
- Go to **Pivot Table Analyze > Filter > Insert Slicer** Slicer after selecting any cell in the PivotTable.
- Choose the fields for which slicers should be created. Then press OK.
- For each option you make, [**Excel**](https://answers.mindstick.com/qa/96517/what-is-ribbon-and-where-does-it-appear-in-excel) will place one slicer on the worksheet; however, you must arrange and size them as you see fit.
- Select the things you want to show in the PivotTable using the slicer buttons.
- **Manually filter the data**
- Select the arrow next to the column heading. The column you want to filter is indicated by a drop-down arrow.
- Uncheck (Select All) the boxes you want to see, then check the ones you want to see. Then press OK.

\

**Read More: [What is the benefit of using formulas in excel sheets?](https://answers.mindstick.com/qa/96527/what-is-the-benefit-of-using-formulas-in-excel-sheets)**


---

Original Source: https://answers.mindstick.com/qa/96521/how-are-pivot-tables-used-to-filter-data-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.