Use a screen reader to filter data in a PivotTable in Excel
Applies ToExcel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016 Excel Web App

This article is for people who use a screen reader program such as Windows Narrator, JAWS, or NVDA with Windows tools or features and Microsoft 365 products. This article is part of the Accessibility help & learning content set where you can find more accessibility information on our apps. For general help, visit Microsoft Support.

Use Excel with your keyboard and a screen reader to filter the data in a PivotTable. We have tested it with Narrator, NVDA, and JAWS, but it might work with other screen readers as long as they follow common accessibility standards and techniques.

With a PivotTable, you can create in-depth detail summaries out of large datasets. To filter your data even further to a smaller portion of your PivotTable, you can insert one or more slicers or apply manual filters.

Notes: 

In this topic

Filter data with a slicer

  1. In your PivotTable, select any cell.

  2. Press Alt+J, T, then S, and F. The Insert Slicers dialog box opens.

  3. You can now select the fields you want to use for filtering your PivotTable. To browse the fields list, use the Down or Up arrow key. To select a field for your PivotTable, press Spacebar. Excel inserts one slicer for each selected field. To insert the selected slicers, press Enter.

  4. The focus moves to the top-most slicer on the worksheet. To switch to another slicer, press the Tab key until you hear the slicer you want. You hear the name of the slicer, followed by "Slicer."

  5. When the focus is on the right slicer, press the Tab key until you hear "Slicer item," followed by the name of a slicer item. Press the Down arrow key until you hear the slicer item you want to use for filtering, and press Enter. The PivotTable is adjusted according to your selection.

    Slicer filters on a worksheet in Excel.  

  6. To clear the filter and display the unfiltered PivotTable, navigate to the slicer you used for filtering, and then press Alt+C.

Filter data manually

  1. In the PivotTable, navigate to the column or row header you want to use for filtering. You hear, for example, "Column label, No filter applied, dropdown button."

  2. Press Alt+Down arrow key to expand the filter menu.

  3. Press the Tab key until you hear: "Manual filter, Select all." The focus is on the (Select All) checkbox. Press Spacebar to clear the checkbox.

  4. Press the Down arrow key to move down on the list of available filters. To select one or more filters, press Spacebar. When you've selected the filters you want, press Enter to apply the filters. The PivotTable is adjusted according to your selections.

  5. To clear the manual filters, navigate to the column or row header used for filtering. You hear, for example, "Column label, filter applied, dropdown button." Press Alt+Down arrow key, then press the Tab key until you hear "Clear filter," and press Spacebar. The filters are removed and the unfiltered PivotTable is displayed.

See also

Use a screen reader to group or ungroup data in a PivotTable in Excel

Use a screen reader to create a chart and select a chart in Excel

Keyboard shortcuts in Excel

Basic tasks using a screen reader with Excel

Set up your device to work with accessibility in Microsoft 365

Use a screen reader to explore and navigate Excel

What's new in Microsoft 365

Technical support for customers with disabilities

Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.

If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.