Excel Quick Tips - How to reorder slicer options in
Want to know how to reorder slicer options in Excel?
Custom lists will be your answer!
Look, optics matter.
Sometimes you want your slicers to be presented in a specific order, but Excel doesn't want to play nice.
In this case, you've got to spell it out for Excel via custom list.
Here's how:
File - Options - Advanced - General - Edit Custom Lists
In here you can either type in your order, or you can import the list you want by linking to a range containing your list (like creating data validation dropdowns).
Hit OK and your slicers will now abide by your custom list as the new default.
Have you given this one a try?
#data #analytics #excel #shorts
Follow for Excel tips, tricks and more!
📢 NEW! Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://tmbanalytics.com/resources
🫵 Ready to take on the 7 Days to Excel Challenge? 👉 Click here if you dare: https://tmbanalytics.com/courses/7-da...
👉 Connect with me on social!
Linkedin: / mattbrattin
Tiktok: / mattbrattin