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 lists

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.

A list in your Web site based on Microsoft is a collection of information that you share with team members. For example, you can create a sign-up sheet for an event, or you can create a list of ideas.

SharePoint team sites include a set of built-in lists. Except for the announcements list, these lists are empty when you create the site.You can immediately fill them with items pertinent to your team. The announcements list contains a sample announcement to help you get started with your site.

You can use the lists that come with your site as is, you can modify or delete lists that you don't use, and you can create your own lists. When you create your own lists, you can base them on the designs used for the built-in lists, or you can create custom lists from scratch.

If you have a -compatible client program, such as Microsoft , and Microsoft Internet Explorer 5 or later installed, you can create lists that are based on spreadsheets.

Windows SharePoint Services enables you to create the following kinds of lists:

Links

A list of hyperlinks to Web pages of interest to team members. By default, a view of the built-in links list appears on the home page.

Announcements

A place to post information for the team. By default, a view of the built-inannouncements list appears on the home page.

Contacts

Information such as name, telephone number, e-mail address, and street address for people who work with your team. By default, a hyperlink to the built-incontacts list appears on the Quick Launch bar.

Events

A list of important dates. By default, a view of the built-inevents list appears on the home page.

Tasks

A to-do list for team members. By default, a hyperlink to the built-intasks list appears on the Quick Launch bar.

Issues

A list you can use to manage a set of issues or problems. You can assign, prioritize, and follow the progress of issues from start to finish.

Custom list

A list with a minimum number of predefined columns. When you want to create a list that is unlike any of the built-in lists, create a custom list.

Data imported from a spreadsheet

If you want to start with a list of information in a spreadsheet, you can define a range of cells to use as a list in your site. Windows SharePoint Services imports the data from the spreadsheet and displays it the same way it displays the built-in lists: in columns that can be filtered and sorted, and accompanied by commands that enable team members to add, edit, and delete items.

There is no link between the original spreadsheet and the list on the site. If you change the spreadsheet, the list on the site is not updated. Likewise, changes to the list on the Web site are not reflected in the original spreadsheet.

Note: To import data from a spreadsheet, you must have a -compatible spreadsheet program, such as , and Internet Explorer 5 or later installed.

Each list appears on a page that includes commands for adding items, sorting and filtering items, switching to a different view of the list, and changing the design of the list. You can copy the list to a spreadsheet, and you can create an alert to be notified of changes to the list from this page. You can also attach a file to any one of the following types of lists: announcements, events, discussions, contacts, and custom lists.

Related Topics

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