Others

How to Sort a Microsoft List by Multiple Columns

Muhammad TalhaMuhammad Talha Oct 10, 2026 869 views

Question details

The user wants to organize list data by sorting it across multiple columns simultaneously, such as sorting by date, then time, and then category.

How to Sort a Microsoft List by Multiple Columns
Product
Microsoft Lists
Device & OS
not provided
Scenario
Organizing and viewing complex dataset items by applying multiple primary and secondary sorting criteria for better data analysis.
Observed behavior
Microsoft Lists only allows sorting by one column directly in the modern list view, and is hard-capped at a maximum of two columns within the standard view List Settings. It lacks native capability to sort by three or more columns.
Before you start

Identify the two most critical data points in your list, as Microsoft Lists restricts native multi-column sorting to a maximum of two columns.

Solution 1Recommended

Configure Sorting by Two Columns Using List Settings

Access the backend list settings to create or modify a standard view, which allows you to define a primary and a secondary sorting column.

While clicking a column header in the modern list view only applies a single-column sort, you can force the list to sort by two variables by editing the underlying view settings.

1
Access List Settings

Open your Microsoft List and click on the gear icon (Settings) in the top right corner, then select 'List settings' from the dropdown menu.

2
Edit the View

Scroll down to the bottom of the settings page to the 'Views' section. Click on the name of your current view (e.g., 'All Items') to edit it, or click 'Create view' to make a new one.

3
Set the Primary Sort Column

Locate the 'Sort' section on the view configuration page. Under 'First sort by the column', select your primary data column from the dropdown list and choose whether to sort it in ascending or descending order.

4
Set the Secondary Sort Column

Immediately below, under 'Then sort by the column', select your secondary data column from the dropdown menu and set its sorting order.

5
Save the View

Scroll to either the very top or bottom of the page and click 'OK' to save your changes. Your list will now load with the two-column sort applied.

Configure Sorting by Two Columns Using List Settings
Free Microsoft Office alternative

Overcome Sorting Restrictions with WPS Spreadsheet

Microsoft Lists restricts your data sorting to just two columns. If you frequently need to organize data by three or more columns (e.g., Date, then Time, then Status), exporting your list to WPS Spreadsheet provides a completely free, unrestricted environment for complex multi-level data analysis.

  1. 1. Export Your List: In Microsoft Lists, click 'Export' and choose 'Export to CSV' or 'Export to Excel'.
  2. 2. Open in WPS Spreadsheet: Launch WPS Office, open your downloaded file, select all data, and click Data > Sort to add as many sorting columns as you need.
Add unlimited sorting levels using the Custom Sort tool to organize complex datasets.Fully compatible with exported Microsoft Excel formats (.xlsx, .csv).Lightweight, fast execution even with large datasets containing thousands of rows.Familiar spreadsheet interface requires zero learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Can I natively sort a Microsoft List by three or more columns?

No, Microsoft Lists does not offer native support for sorting by three or more columns. You are restricted to sorting a maximum of two columns through the List Settings menu.

Why does clicking column headers only sort one column at a time?

The modern list view interface is designed for quick, single-column sorting overrides. To apply a permanent sort involving two columns, you must configure it within the backend List Settings under the standard view options.

How can I achieve advanced sorting if Microsoft Lists doesn't support it?

If your project requires advanced data organization, you can use the 'Export to Excel/CSV' feature from the Microsoft Lists top menu, then open the file in a dedicated spreadsheet tool like WPS Spreadsheet or Excel to apply unlimited Custom Sort levels.