Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

About views

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Views make it quick and easy to see information in a variety of ways.You can use views in list (such as Announcements, Contacts, and so on), andyou can also use them in libraries, surveys, anddiscussion boards.

When you create a view, ahyperlink tothe view is added to theview bar on thepage that displays the list. An indicator marks the active view, asshown:

Cc723110.ZA060489641033(en-us,TechNet.10).gif

You can create custom views to do one or more of the following:

  • Filter by a set of criteria

  • Sort in a particular order

  • Hide or show columns

  • Group information based upon list data

  • Display subtotals of columns

  • Show lists with date information as calendars or tables

For example, instead of applying the same filter every time you go toa particular list, you can create a view that includes the filter. Then, to seethe filtered information, you can click the hyperlink to the view you created.You can even make your new view the default shared view, so that when your teammembers go to the page that displays a list, they automatically see thefiltered information.

About standard views and datasheet views

Standard views display list information in themanner that you specify. You can view and work with list data from anysupported Web browser. Standard views require no special software on yourcomputer. In a standard view, you filter, update, add, or delete items one at atime.

Datasheet views require that you have a Windows SharePoint Services-compatible datasheet program installed, such as Microsoft. Datasheet views allow you to quickly add, delete, and updatelist entries just as you would in a spreadsheet program, such as MicrosoftExcel, without having to switch to a separate program.

If you click a datasheet view and don't have a datasheet program compatible with Microsoft installed, the list will appear in the standardview. Conversely, if you have a datasheet program installed and you want togo to a standard view, you can click the Edit in Datasheet button to automatically createa datasheet view and edit the list information in the datasheet.

About shared views and personal views

You can create shared views that all site users can use. However, ifa Web site has many users and each creates a shared view, the list of sharedviews can get very long. Personal views enable each user of a SharePoint siteto create his or her own views, which are not visible to other users. Havingboth types of views allows site administrators to ensure that only views thatare useful for most users appear in the list of shared views, but still allowsusers to create personal views that help them view list information in the mostconvenient way for them.

Note: The types of views you can create may vary based on the template your site uses.

Grouped views

Grouped views let you group the items in a list based on one or twocolumns. For example, you can group items in the events list so that allevents that occur on given day appear together. You can then group the eventswithin that group based upon who arranged the event or where the events areheld.

Note: When you create a datasheet view, it cannot also be a grouped view. To create a grouped view and use the easier editing tools thata datasheet view provides, create a standard view. On the list page,click Edit in Datasheet . You can then click Show in Standard View to return to the grouped view.

Calendarviews

If your list includes a column with dates, you can create a view thatdisplays the list as a calendar. This feature allows you to create a customlist that you can view either as a standard tabular view, or as a calendar. Youcan switch between the two views quickly.

Related Topics

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft