Office Compatibility Issues

Find Custom Lists in Excel for Linux and Microsoft 365

Steven ParkerSteven Parker Nov 12, 2026 868 views

Question details

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

Find Custom Lists in Excel for Linux and 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the desktop Excel application

Launch Excel on a Windows or macOS computer and open the workbook containing the data you want to sort.

2
Open Excel settings

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.

3
Open the Custom Lists settings

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.

4
Create or select a list

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.

Linux limitation: Excel does not provide a native desktop application for Linux. If you are using Excel in a Linux browser, the Custom Lists setting is unavailable.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office for your Linux computer, then open WPS Spreadsheet from the application menu.
  2. 2. Open the Excel workbook: Select Open from the WPS Spreadsheet home screen and choose the .xlsx file you want to organize.
  3. 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.
Work with spreadsheet files on Linux without requiring a Windows or macOS Excel desktop installation.Use a familiar spreadsheet interface for organizing and sorting data.Open, edit, and save Microsoft Excel .xlsx workbooks with broad format compatibility.Move from Excel for the web to a lightweight desktop-style office suite with minimal workflow changes.
microsoft office alternative - wps office

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.