Use sorting to modify a SharePoint view

Use sorting to modify a SharePoint view

Sorting helps you organize your data into a specific order based on column data. There are two ways to sort a view, a quick sort from the view itself, and a more flexible and persistent sort created in a view. When you sort, you are only rearranging how the data is displayed, not adding or removing content that is displayed in the view.

Sort data from within a view

In any view, you can click the header of a column of a list or library and select ascending or descending sort.

The drop down sorting menu on a column header

You can choose any column to sort, but only one column at a time. When you close the list or library, the column will return to its default view order.

Create a sorted view

When you create or edit a view, you can specify sorting on one or two columns. You can sort on columns, even if they're not visible in the view. To set up a sort, follow these steps:

  1. Do one of the following:

    To Create a view

    In SharePoint Online, click View options, click Save view and give the view a name. From the new view, click Edit current view.

    In SharePoint Server, click the Library tab, and then click Create view.

  2. On the create or edit a view page, scroll down to Sort. In the Sort section, click the First sort by the column drop down and choose a field. This field is one of the many available columns for your list or library, and can be one that is in the view or not.

  3. Click Show the items in ascending order or Show the items in descending order.

  4. If you want to sort additionally with another column, choose a column in Then sort by the column, and then set the order to sort by.

  5. Scroll to the top or bottom of the page and click OK.

Modify a sorted view

To Edit a view

  • Open the list or library.

  • In SharePoint Online, click View options, and then click Edit current view.

    View options menu with edit current view highlighted


    In SharePoint Server, click the Library tab, and then click Modify view.

    SharePoint Online Ribbon Library tab modify view option
  • Scroll down to the Sort section.

  • You can then change settings as outlined in steps 2 through 5 in the Create a sorted view procedure above.

Filter and group your sorted data view

You can combine sorting with a filtered and/or a grouped view. Grouping allows you to collapse sorted areas under headers, and filtering can be used to narrow down a large list of items.

To see how to group data in a view, see Use grouping to modify a SharePoint view.

To learn how to filter data in a view, see Use filtering to modify a SharePoint view.

We're listening

Created April 29, 2017

Was this article helpful? If so, please let us know at the bottom of this page. If it wasn't helpful, let us know what was confusing or missing. Please include your SharePoint, OS, and browser versions you're using. We'll use your feedback to double-check the facts, add info, and update this article.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.