Forum Discussion

Jophassa's avatar
Jophassa
Copper Contributor
Dec 06, 2023

How to find Custom Lists in Excel on Linux (Office 365)

Hi, currently stuck trying to find Custom Lists on Excel, Linux.   I've tried under File, Options, but only see how to change Regional Settings.   Also tried the below method but there isn't a Cu...
Excel
Excel for web
office 365
JKPieterse's avatar
JKPieterse
Silver Contributor
Dec 06, 2023

Since there is no Excel version for Linux that I am aware of I suspect you are using Excel on-line. That version does not support custom sort lists.

  • Jophassa's avatar
    Jophassa
    Copper Contributor
    Dec 06, 2023

    Hi, yeah, using the Office 365 version...so there's no way to access custom lists unless I have the application installed onto my Windows computer? Cheers JKPieterse 

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Dec 08, 2023
      Windows or Mac indeed.
    • peiyezhu's avatar
      peiyezhu
      Bronze Contributor
      Dec 07, 2023
      Linux?
      How about online sql?
      you can sort by custom order with sql like:

      select * from Sheet1 order by instr('b,c,e,a',field)

Resources