Create a filtered view by using an indexed column

After you index a column, you can add it to a new view as you create the view and then use the indexed column to filter the view. Before creating a view, you may want to add more columns to enable more flexibility for sorting, grouping, and filtering. If you are creating a view for a mobile device, you should consider the limits of your group's mobile devices. Find links to more information about creating columns and views in the See Also section.

1. If the list or library is not already open, click its name on the Quick Launch.

If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.

2. On the View menu , click Create View.
3. Under Choose a view format, click the type of view that you want to create. For most situations in libraries, you can click Standard View, but you can choose other views for specific situations.
4. In the View Name box, type a name for your view, such as Sorted by Last Name.
5. In the Filter section, click Show items only when the following is true, and then choose how you want to filter the items based on one of the columns that is indexed. For example, to create a view of only items that changed today, choose the Modified (Indexed) column and the is equal to condition, and then type [Today].

 Note    If you do not see any columns that say (Indexed) after the name, you do not have any indexed columns available for that list or library. You must index a column first.

6. Choose any other options that you want for your view, such as which columns you want to show or hide and how you want to sort the items.
7. Click OK.