![]() ![]() ![]() Excel for the web supports slicers, but you can’t create a custom sort list in the web version. I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions of Excel through 2010. SEE: Windows, Linux, and Mac commands everyone needs to know (free PDF) (TechRepublic) In this tutorial, I’ll show you how to create a custom list of t-shirt sizes and then sort slicer buttons by sizes instead of alphabetically. When that happens, create a custom sort list to sort the slicer buttons. Occasionally, you’ll be working with items that aren’t well represented by a traditional sort. When you base the slicer on one of the fields in the PivotTable, Microsoft Excel sorts the buttons alphabetically or numerically. If you do a lot of analyzing and summarizing by groups, you probably build your fair share of PivotTables and slicers. For more info, visit our Terms of Use page. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary. Microsoft Excel sorts slider buttons alphabetically and numerically. How to use a custom sort on slicer buttons in Microsoft Excel ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |