How to sort columns in a SharePoint Online list?

I will show how to sort columns in a SharePoint Online list in this SharePoint Online tutorial. Then I will explain how to sort columns in a SharePoint Online list using quick sort and also how a SharePoint list sort multiple columns.

Sorting in a SharePoint Online list column

In SharePoint, sorting helps users to organize their data into specific order based on column data. When the user sorts, it will only rearrange how the data is displayed, not adding or removing content that is displayed in the view.

Sort Column in a SharePoint Online List using Quick sort

Let’s see how to sort columns in a SharePoint Online List using quick sort.

Quick sort only applies to the number column, date column, and text column as quick sort only sorts one column at a time.

Here, I will show how to sort SharePoint Online List Columns such as the Text column, Number column/Currency column, and Date column using Quick Sort.

I will use This SharePoint Online List to sort in the SharePoint Online list.

Sort Currency Columns in a SharePoint Online List Using Quick Sort

Here, I will show you how to sort the currency column in a SharePoint Online list using quick sort. To achieve it, follow the below steps.

There are two types of sorting options available such as:

1. Smaller to larger
2. Larger to smaller

This sorting option in the SharePoint Online list only applies to the number and currency columns.

Smaller to Larger:

• Open the SharePoint Online list, dropdown the currency column, then click on Smaller to larger, as shown below.

• Then, you can arrange the currency column in the SharePoint Online List from lower to higher.

Larger to Smaller:

• Dropdown the currency column and select Larger to smaller to sort the SharePoint Online list column. Then, you can see the SharePoint Online currency column arranged from higher currency rates to lower currency rates.

This is how we can sort currency columns in a SharePoint Online list using quick sort.

SharePoint Online List Sorting Text Column

Let’s see how to sort text column in a SharePoint Online list using a quick sort. There are two options available such as:

• A to Z
• Z to A

These sorting options are applicable for single-line text and multiple-line text columns.

1. A to Z

• Open a SharePoint Online document library, drop down any text column as per your need, then select A to Z. Now you can see the column get arranged alphabetically as shown below.

• Z to A: Here, you can follow the above steps and select Z to A, then, you can see the text column arranged in reverse alphabetical order as shown below.

This is how we can sort text columns in the SharePoint Online list.

SharePoint Online List Sorting by Date

Let’s see how SharePoint Online lists sorting by date. There are two options available to sort number columns using quick sort such as:

• Newer to older
• Older to newer

1. Newer to older

• Open a SharePoint Online document and dropdown the date column, then select Newer to older. Now you can see the SharePoint list date column arranged from the recent date to the previous date.

2. Older to newer: Follow the above steps and select Older to newer then the SharePoint Online date column gets arranged from the previous date to the recent date as shown below.

This is how to sort the date column in a SharePoint Online list.

SharePoint List Sort Multiple Columns

Let’s see how to sort multiple columns in the SharePoint Online list.

I will implement multiple sort conditions on a default view in the SharePoint Online list. So, to do that, I have to use edit current view.

• Open a SharePoint Online list, and dropdown All items, then click on Edit current view.

• In this Edit View tab, go to Sort to select up two columns to determine the order in which the items in the view are displayed such as:
  • First sort by the column: Here, select the first column to sort, then select show items in ascending or descending order. I have selected Show items in descending order.
  • Then sort by the column: Select the second column, which will be sorted, and also select Show items in ascending or descending order. I have selected Show items in descending order.
• Then click on the OK button.

• Then, you can see both columns arranged in descending order displaying the recent date first and then the previous date as shown below.

This is how to sort multiple columns in a SharePoint Online list view.

Conclusion

From this SharePoint online tutorial, I have explained how to sort columns in a SharePoint Online list. Then, I will show how to sort columns in a SharePoint Online list using quick sort and also how SharePoint Online list sort multiple columns using edit current view.

• Create a Lookup Column in SharePoint Online List
• How to Setup Alerts in SharePoint
• SharePoint number column without comma
• Export SharePoint List to Excel
• Rename a SharePoint Online List