Filter data in a PivotTable

You can view and interact with PivotTables in Excel Online, which includes some manual filtering and using slicers that were created in the Excel desktop application to filter your data. You won’t be able to create new slicers in Excel Online.

To filter your PivotTable data, do one of the following:

  • To apply a manual filter, click the arrow on Row Labels or Column Labels, and then pick the filtering options you want.

Filtering options for PivotTable data

  • If your PivotTable has slicers, just click the items you want to show in each slicer.

Slicer with selected items

If you have the Excel desktop application, you can use the Open in Excel button to open the workbook and apply additional filters or create new slicers for your PivotTable data there. Here’s how:

Click Open in Excel and filter your data in the PivotTable.

Open in Excel button

For news about the latest Excel Online updates, visit the Microsoft Excel blog.

For the full suite of Office applications and services, try or buy it at

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!