Forum Discussion

Molly629's avatar
Molly629
Copper Contributor
Aug 30, 2022

How can I customize Excel's alphabetical sorting methods?

I am an editor and part of my job involves working with long lists of terms and names. We use the Chicago Manual of Style's "letter-by-letter" alphabetization method, which is one of the most common....
excel
Excel on Mac
Molly629's avatar
Molly629
Copper Contributor
Aug 31, 2022
Thanks so much for the fast response! Yes, I think that's just what I'm looking for... unfortunately I have a macbook from my work and I can't install any third-party software on it (admin password lock). Maybe they will roll out the feature officially one day? 😕 But I will keep this in mind if I ever need it on my personal PC, very good to know!
JimGMac's avatar
JimGMac
MVP
Aug 31, 2022

Molly629 

 

Hi again,

Just to keep you up to date, Mac Excel has full PowerQuery capabilities in the current channel build that you already have IF you are skilled in Microsoft Visual Basic for Applications. Click here for a web search with lots of useful links.
The object model of Excel for Mac and Windows, as well as the code base is the same regarding PowerQuery. What's currently absent in the general release build on the Mac is the PowerQuery interface. That's what is currently being tested.

If you receive a workbook having a PowerQuery you can currently refresh the data in the Mac Excel interface, but not much else. But if you know VBA, you can use all PowerQuery functionality right now because Mac Excel has VBA (and you can also use AppleScript or Objective-C if you prefer).

 

Resources