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

You can use views to see the items in a list or library that are most important to you or that fit a particular purpose. For example, you can create views of the files in a library that apply to a specific department or the items in a list that were created by a specific person. Views are available for the list or library you create them in.

Each list or library has at least one view. In the browser, you can modify these views and create new views. For example, a task list includes several views, such as All Tasks and My Tasks. You could modify these views by changing how the items in the list are sorted. Or you could create a new view that shows only that tasks that are incomplete.

In addition to using the browser, you can use Microsoft Access to create forms and reports that are based on the list.

In this article


Planning your view

Before you begin

Before creating a view, you may want to add columns to the list or library to enable more flexibility for sorting, grouping, and filtering the items in the list or library. For example, people may want to see only the documents in a library that apply to their department or the items in a list sorted by the project number. For more information about adding columns, see Create, change, or delete a column in a list or library.

If you are creating views that will be accessed by phones and other mobile devices, you need to consider the capabilities of the mobile devices.

Top of Page Top of Page

Types of views

When you create a view, you first choose whether you want to base the view on:

  • A predefined format, such as Calendar
  • An existing view
  • Forms and reports created by using Microsoft Access

The option that you choose determines the requirements for the data in the list or library and how the information will be displayed. For example, to create a Calendar view, the list or library must contain columns that can be used for the start dates and the end dates of the calendar items.

 Note    Once created, you cannot change the format of a view, such as from a calendar to a Gantt view.

All predefined formats are not available for all types of lists and libraries. For example, there are view formats that are available only for discussion boards. The following are the formats available. Custom formats may also be available on a site.

  • Standard View    This view displays your list and library items one row following another. Standard view is the default for most types of lists and libraries. You can customize the view in many different ways, such as by adding or removing columns from the view.

A standard view

  • Standard View, with Expanded Recurring Events    This view displays your list and library items one row after another. Use this view if you want to see each instance of a recurring event.

 Note    This view is available in a Calendar list only.

Standard View with Expanded Recurring Events.

  • Calendar View    This view displays your list and library in a format similar to a wall calendar. You can apply daily, weekly, or monthly views in this format. This view can be helpful if you want to see the items in the list or library chronologically. Calendar views have requirements that differ from the other formats.

Calendar view

  • Datasheet View    This view displays list and library items in a grid, similar to a spreadsheet. This view, also known as Quick Edit, can be helpful if you have to edit many items in a list or library at the same time. This view is also helpful if you want to export your data to a spreadsheet or database program.

Datasheet view

  • Gantt View    This view displays list and library items in bars that track progress. A Gantt view can help you manage projects. You can use this view, for example, to see which tasks overlap each other and to visualize overall progress.

Gantt view

  • Access View    Use Microsoft Access to create forms and reports that are based on the list or library.

Create a view with Microsoft Access

  • Existing view     If an existing view is almost the view that you want, you can save time by using an existing view as the starting point for creating your new view.

Start from existing view

Top of Page Top of Page

Settings for views

Views have many settings to help make it easier for you to quickly find the information that you need in a list or library. The following are the settings for SharePoint views. All settings are not available for all types of views. The settings for calendar views differ from other types of views.

 Important    The maximum number of items in a view is 5000. You can manage the number of items in a view by using the filter and item limit settings.

  • Default view    All lists and libraries have a default view, which is the view that people see when they go to the list or library. You can change the default view to any public view for that list or library; 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 or library.

     Note    If Make this the default view is not displayed on the create or edit view pages, you do not have the permissions (permissions: The specific security settings that allow or restrict access to a given item, list, library, or site.) to create a public view or the view is a personal view. To create a public view you need to be in the Designer group for the list or library, or have the equivalent permissions.

  • Personal and public views    When you create a view, you can set the audience for the view to be personal or public. A personal view is a view that only you can see. A public view is a view that anyone can see.

You cannot change a personal view to a public view or a public view to a personal view. You can use a public view as the starting point for personal or public views. You can use a personal view as the starting point only for personal views.

When you create a view, if Create View is disabled you do not have the permissions to create a view. If the Create a Public View option is disabled you do not have the necessary permissions to create a public view. To create a personal view, you need to be in the Member group for the list or library, or have the equivalent permissions. To create a public view, you need to be in the Designer group for the list or library, or have the equivalent permissions.

  • Columns    The columns in a view contain the information that you need to see for list or library items. Columns, in combination with other features of views, such as filters, can help you see only the information that is most important to your work. This is especially helpful if the list or library contains lots of items. For more information about working with columns to create custom views, see the Column types and options article.
  • Gantt Columns    Select the columns that will be in the Gantt view. Title is a required text field. Start Date, and Due Date are required date fields. When you select a column, such as Title, if no option displays in the drop-down list, you must create the column to support this view.
  • Sort    Set the order in which items appear in the view. You can have up to two criteria. For example, show the items in a task list sorted by priority and then by due date.
  • Filter    Configure a view to display a subset of the items in a list or library by filtering them with information in columns of the list or library. For example, a view can show the documents in a library that are for a specific project.

     Tip    You can use some functions as filters, such as [Today] to show items when the date matches today or [Me] to show items for the user of the view. You can also combine simple equations with functions. For example, to show items created in the last seven days, filter on the Created column, set the operator to is less than, and set the value to [Today]-7 (no spaces). For more information, see the Introduction to data calculations article.

  • Tabular View    Provides check-boxes for each item so that users can select multiple list or library items to perform bulk operations. This can save lots of time if many items in a list or library must be changed. For example, a user can select and check out multiple documents.
  • Group By    Group list and library items by information in the columns. For example, group the items in a task list by priority and then percent complete.
  • Totals    Displays summary calculations for the columns in the view, such as: count, average, maximum, minimum. By setting the title column to Count in a document library, for example, the view will display the number of documents in the view and in the groups in the view. The columns that are available for totals and the settings available for each column differ depending on the type of column, such as number, and the type of list or library the view is being created for.
  • Style    Determines the layout for the view, such as newsletter. All styles are not available for all view types.
    • Basic Table    Displays items in rows.
      A standard view
    • Boxed    Displays the items in the list using a layout similar to business cards. This style is available only for lists.
      Boxed style view
    • Boxed, no labels    Similar to the boxed style, but the labels for the columns are not in the view. This style is available only for lists.
    • Default    The default view varies, depending on the type and configuration of the list or library.
    • Document details    Displays the files in a library using a layout similar to business cards. This style is available for most libraries, but not lists.
      Document details view
    • Newsletter    Displays items in rows with lines between the rows.
      Newsletter styl view
    • Newsletter, no lines    Displays items in rows of alternating shades, without the lines between the rows.
      Newsletter no lines view
    • Preview Pane Displays the name of the items on the left side of the page. When you point to the name of an item, the columns selected for the view are displayed on the right side of the page.
      Preview Pane View Style
    • Shaded    Displays items in rows of alternating shades.
      Shaded view

Top of Page Top of Page

Create a view

When you look at a list or library, you can temporarily sort or filter the items or files by pointing to the name of a column and then clicking the arrow next to the name. This is helpful if you only occasionally want to see the list or library like this, because you have to repeat these steps the next time that you want to view the list or library this way.

Sort or filter a column

If you frequently have to view information in a list or library a certain way, you can create a view. When you create a view, it is added to the view menu of a list or library.

Select a different view

To create a view:

  1. In the list or library where you want to create a view, click the List or Library tab, and then click Create View.

     Note    If Create View is disabled, you don’t have the permissions to create a view. For information about the permissions you need to create personal and public views, see Settings for views in this article.


    Create a view in a list
  2. Click the format, such as Standard View, or an existing view that you want to base your view on.
  3. In the View Name box, type the name for your view. Select Make this the default view if you want to make this the default view for the list or library. Only a public view can be the default view for a list or library.
  4. In the Audience section, under View Audience, select Create a Personal view or Create a Public view.

     Note    If Create a Public View is disabled, you don’t have the permissions to create a public view for this list or library.

  5. In the Columns section, select the columns that you want in the view and clear the columns that you don’t want to appear. Next to the column numbers, select the order that you want to columns to appear in the view.
  6. Configure the other settings for your view, such as Sort and Filter, and click OK. For more information about view settings, see Settings for views in this article.

Top of Page Top of Page

Change a view (includes select another view)

Use the following steps to change a view, such as making it the default view, adding or removing columns, and changing the sort order of items in the view.

  1. In the list or library where you want to change a view, click the List or Library tab.
  2. Select the view you want to change from the Current View drop-down list.

Select a different view

  1. Click Modify this View.

     Note    If Modify this View is disabled, you don’t have the permissions to modify the current view. You can, however, modify your personal views. For information about the permissions you need to create personal and public views, see Settings for views in this article.


Top of Page Top of Page

Delete a view

Use the following procedure to delete a view for a list or library.

 Note    If Delete is not an option, this may be the default view for a list or library. You must first modify another view and make it the default. For more information about changing a view, see Modify a view in this article.

  1. In the list or library where you want to delete a view, click the List or Library tab.
  2. Select the view you want to delete from Current View drop-down list.
    Select a different view
  3. Click Modify this View.

     Note    If Modify this View is disabled, you do not have the necessary permissions to modify the current view. You can, however, modify your personal views. For information about the permissions you need to create personal and public views, see Settings for views in this article.


    Modify a view
  4. In the top area of the view, click Delete.
  5. When prompted, click OK.

Top of Page Top of Page

 
 
Applies to:
SharePoint Foundation 2013, SharePoint Online Enterprise (E1), SharePoint Online Enterprise (E3 & E4), SharePoint Online Midsized Business, SharePoint Online operated by 21Vianet - Enterprise (E1 & E2), SharePoint Online operated by 21Vianet - Enterprise (E3 & E4), SharePoint Online operated by 21Vianet - Midsized Business, SharePoint Online operated by 21Vianet - Small Business, SharePoint Online Small Business, SharePoint Server 2013 Enterprise, SharePoint Server 2013 Standard