Find Custom Lists in Excel for Linux and Microsoft 365
Question details
The user needs to locate and use Custom Lists for sorting Excel data while working on Linux or Microsoft 365.

- Product
- Microsoft Excel for the web or Excel desktop
- Device & OS
- Linux or web browser
- Scenario
- The user follows instructions to open File > Options but cannot find the Options command and needs custom sorting for Excel tables.
- Observed behavior
- Excel for the web does not provide the Custom Lists setting, and Excel does not offer a native desktop application for Linux.
Check whether the workbook is open in Excel for the web or in a Windows or macOS desktop installation. If you are using the web version, identify the column that can serve as a helper column for assigning sort order.
Use desktop Excel on Windows or macOS to manage Custom Lists
Use this option when you need Excel's native Custom Lists feature to create or edit a custom sort order.
Excel for the web does not support custom sort lists. The Custom Lists setting is available in the desktop versions of Excel for Windows and macOS, not in a native Linux desktop version.
Launch Excel on a Windows or macOS computer and open the workbook containing the data you want to sort.
In Excel for Windows, select File, choose Options, and open the Advanced category. On macOS, open the Excel menu and choose Preferences or Settings, depending on your version.
In the Advanced settings, scroll to the General section and select Edit Custom Lists. On macOS, open the Custom Lists setting from Excel Preferences or Settings.
Enter the list items in the List entries box, select Add, and choose OK. Then select a cell in your table, open Data > Sort, and choose the custom list under Order.
Sort with a helper column in Excel for the web
Use this workaround when you must stay in Excel for the web and need a reliable custom order.
Use WPS Spreadsheet for custom sorting on Linux
WPS Office provides a free, lightweight spreadsheet alternative for Linux users who need to open, edit, and sort Excel workbooks without relying on Excel for the web. Its familiar spreadsheet interface and Microsoft Office compatibility make migration straightforward.
- 1. Install WPS Office: Download and install WPS Office for your Linux computer, then open WPS Spreadsheet from the application menu.
- 2. Open the Excel workbook: Select Open from the WPS Spreadsheet home screen and choose the .xlsx file you want to organize.
- 3. Create a custom sort order: Use the Data tab and the available Sort tools to arrange the worksheet, or add a numeric helper column when you need a specific category sequence.

Frequently Asked Questions
Why can’t I find File > Options in Excel on Linux?
Excel does not have a native desktop application for Linux. You are likely using Excel for the web in a browser, where the File > Options command and Custom Lists settings are not available.
Does Excel for the web support Custom Lists?
No. Excel for the web does not support creating or managing custom sort lists. Use Excel desktop for Windows or macOS, or sort with a helper column.
Can I create a custom sort list in Excel for Windows?
Yes. Open File > Options > Advanced, scroll to the General section, select Edit Custom Lists, add the list entries, and then choose that list in Data > Sort.
What is the best workaround for custom sorting in Excel for the web?
Add a Sort Order helper column, assign a number to each category according to the required sequence, and sort the table by that column from Smallest to Largest.
Can WPS Spreadsheet open my Excel workbook?
Yes. WPS Spreadsheet can open, edit, and save Microsoft Excel .xlsx files, allowing Linux users to work with compatible spreadsheet documents outside Excel for the web.




