Get started with Lists

Edit a list view

Your browser does not support video.

Note: If your screen looks different, 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.

Try it!

Edit a list view to show just the columns and items you want. 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.

Show or hide columns

  1. Select the column heading, then select Column settings > Show/hide columns.

  2. Select the check boxes to choose which columns you want to see.

  3. Select Apply.

Move a column

  • Drag the column heading to where you want it.

Change the sort order or apply a filter

Select the column heading, and from the column heading list:

  • Select a sort method (such as A to ZAscending, or Older to newer) to change the sort order. The options are based on the column type and will vary accordingly.

  • Select Filter by to apply a filter. In the filter pane, select the options you want, and then select Apply.

Save the view

In the top navigation, select the name of the view you edited from the View options menu (for example, select All items*), select Save view as, and then:

  • To save your changes to the current view, just select Save in the Save as box.

  • To create a new view without changing the old one, enter a new name, and then select Save.

Note: Use the check box in the Save as box to choose whether you want the view to be public or private. 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.

Show or hide columns

  1. Tap More > Show/Hide/Reorder Columns.

  2. Tap the toggle switch of the column you want to show or hide.

Move a column

  1. Tap More > Show/Hide/Reorder Columns.

  2. Tap and hold the name of the column you want to move, then drag it to a new position in the list.

  3. Release the item in the new position.

Change the sort order of a column

  1. Tap Sort.

    In the Sort list, blue lettering shows which column the list is currently sorted on.

  2. Tap the column name you want to sort on.

  3. Select the sort order you want.

The new sort order is applied to the list.

Apply a filter to a column

  1. Tap Filter.

  2. Tap the column name you want to filter on.

  3. Select the filter order.

    The new filter order is applied to the list.

  4. Tap Apply.

Group items

  1. Tap Group.

  2. Tap the column name you want to group by.

The new group order is applied to the list.

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.