Related topics
Get started with Lists
Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Get started with Lists

Create or change the view of a list

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Set up your list to show your data just the way you want it. Organize your list in a custom way to emphasize a certain thing or to have a more engaging style. 

Switch to a different view

Select the name of the view you're editing from the View options menu (for example, All items), then:

  • Select the name of the view you want to change to, or

  • Select a different view type, like List, Compact List, or Gallery.

Add a column

Select Add column, or:

  1. Hover between two column headings and select the + sign.

  2. Choose the type of column you want to add, enter the information for your column, and then Save

You can also add a column by selecting Add column in the right-most column header.

Sort a list

  • Select the column heading you want to sort on and choose a sort order.

Filter a list

  • Select the column heading and then select Filter by, select the items you want to see, and Apply.

  • To clear the filter, select the column heading, then select Filter by > Clear all > Apply.

Group items

  • Select the column heading, then the Group by option.

Save the view

  1. Select the name of the view you're editing from the View options menu (for example, All items) and then select Save view as.

  2. Enter a name, choose between a public or private view, and Save.

Want more?

Create, change, or delete a view of a list or library

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!