With quarters being classified as the 'popular' buttons, we will definitely want to make these show up on the top row. In this scenario, the quartes are going to be the more popular way at looking at the data as the team that uses this file only reports results every 3 months. Let's look at an example situation where we want to create Slicer buttons that give our users the ability to filter on a particular month or quarter. Real World Example With Quarters and Months Since you can't always depend on your most popular buttons starting with the letter 'A' this could pose a problem. Slicers only allow you to organize your buttons in alphabetical order (ascending or descending). This is because most people are going to scan through the buttons similar to how they read a book and you don't want to waste your user's time by placing the most popular buttons somewhere in the middle of the sea of buttons. When you are creating Slicer buttons you typically want to keep your most used buttons on the top row. One of these limitations is manipulating the order in which the Slicer buttons are organized. Unfortunately, Microsoft has left these handy little buttons very simple in their functionality which has hindered some of us creative folks from pushing them past their limits. They allow you to ditch the need for drop-down lists and instead give your users the ease of simply selecting a button to filter/change the displayed data. Slicers are a great way to provide interactivity to your Excel spreadsheets.

How do slicers work in excel