Add a slicer with Excel Online

Last Updated on 30/10/2024
Reading time: 2 minutes

How to add a slicer with Excel Online? There are 2 techniques

Update of the ribbon of Excel Online

Working with Excel Online can be challenging due to the unpredictable nature of its updates. The timing and specific areas of these updates are often uncertain. For example, when I wrote this article in November 2020, the Pivot Table ribbon lacked an option to add a slicer. But since 2023, the Slicer menu has been added to the ribbon 😀👍

New Slicer menu for Excel Online

And also, you can notice that the general interface of Excel Online looks similar to the Excel desktop ribbon.

Technique #2: Use the right-click to add a slicer with Excel Online?

This was the only way to add a slicer in Excel Online before 2023.

  1. Go to the Pivot Table pane
  2. Put your mouse over a field
  3. Click on the arrow on the right
  4. Select the option Add a slicer
Add Slicers with Excel Online

The trick is so impressive that it has now been incorporated, with some variation, into the Excel desktop version.

  1. Go to the Pivot Table pane
  2. Put your mouse over a field
  3. Right-click on the field
  4. Select the option Add a slicer
Shortcut to add slicers with Excel desktop

In conclusion, this second technique is my favorite, even with Excel Desktop. Why? You save a lot of time here.

  • With the second technique, you can quickly add a slicer for any field.
  • With the first technique, you must open each table before finding the field you want as a slicer.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Add a slicer with Excel Online

Reading time: 2 minutes
Last Updated on 30/10/2024

How to add a slicer with Excel Online? There are 2 techniques

Update of the ribbon of Excel Online

Working with Excel Online can be challenging due to the unpredictable nature of its updates. The timing and specific areas of these updates are often uncertain. For example, when I wrote this article in November 2020, the Pivot Table ribbon lacked an option to add a slicer. But since 2023, the Slicer menu has been added to the ribbon 😀👍

New Slicer menu for Excel Online

And also, you can notice that the general interface of Excel Online looks similar to the Excel desktop ribbon.

Technique #2: Use the right-click to add a slicer with Excel Online?

This was the only way to add a slicer in Excel Online before 2023.

  1. Go to the Pivot Table pane
  2. Put your mouse over a field
  3. Click on the arrow on the right
  4. Select the option Add a slicer
Add Slicers with Excel Online

The trick is so impressive that it has now been incorporated, with some variation, into the Excel desktop version.

  1. Go to the Pivot Table pane
  2. Put your mouse over a field
  3. Right-click on the field
  4. Select the option Add a slicer
Shortcut to add slicers with Excel desktop

In conclusion, this second technique is my favorite, even with Excel Desktop. Why? You save a lot of time here.

  • With the second technique, you can quickly add a slicer for any field.
  • With the first technique, you must open each table before finding the field you want as a slicer.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *