Edit a list view

There are many ways to edit a list view in a list. You can present data with different styles, subgroups, columns, sorts, and filters. Note that you need Contribute permission level or higher to edit a view.

Your browser does not support video.

Note: Does your screen look different than the examples here? Your administrator may have classic experience set on the list, or you're using an earlier version. If so, see Edit a list view in SharePoint Server.

  1. Open the list that you want to edit.

  2. Modify the list view by doing one or more of the following:

  • To add a column, select the header of any existing column, and from the dropdown menu, select Column Settings > Add a Column. (You can also select + Add column or + to the right of the last column name at the top of the list.)

  • In the Create a column pane, enter the column information, then select Save.

    The create a column panel
  • To sort a column, select the column header, and from the dropdown menu, your first two options will be the sort methods (such as A to Z or Descending). The options are based on the column type and will vary accordingly.

    From the column header menu in the List view, the Sort option selected in the modern SharePoint experience
  • To filter a column, select the Filter icon Filter icon . When the pane options, you'll see all the filter options for all columns that can be filtered. Select the checkbox or checkboxes accordingly.

    The Filter option selected in the List view in the modern SharePoint experience

    (You can also select the column header, and from the dropdown menu, select Filter by. When the pane opens, select the option or options you want to use to filter the column, then select Apply.)

  • To group items in the list together, select the column header, then from the dropdown menu, select Group by. (In the example below, items in the list are grouped by Event Coordinator.)

    From the column header menu in the List view, the Group by option enabled in the modern SharePoint experience
  • To modify column settings, select the column header, then from the dropdown menu, select Column settings, and then Edit.

Saving the list view

Once you have your view the way you like it, you can save it.

  1. From the top navigation, select All Items*.

  2. From the dropdown menu, select Save view as, then in the dialog box, enter the name you want to give this view.

  3. If you want the view to be shared publicly as well, check the Make this a public view box.

  4. Select Save.

You can change the default view to any public view for that list. But you cannot set a personal view as the default view. To delete a view that is the default view, you must first make another public view the default for that list. If Make this the default view is not displayed on the create or edit view pages, you do not have the permission to create a public view, or the view is a personal view.

Leave us a comment

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. We'll use your feedback to double-check the facts, add info, and update this article.

Need more help?

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.

×