Share Point 2010:Create a list by using a list template

SharePoint includes many kinds of list templates, such as calendar, survey, and tasks. Templates make it easier for you to create the lists that you need.

Create a list from the Site Actions menu by using a list template

1. Click Site Actions , click View All Site Content, and then click Create .

Note A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

2. Under Communications or Tracking click the type of list that you want to create, such as Contacts or Calendar. Find more information about lists and related features in the See Also section.
3. Type the Name for the list. Name is required.

The name appears at the top of the list in most views, becomes part of the Web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the Web address will remain the same.

4. Type the Description for the list. Description is optional.

The description appears underneath the name in most views. Some kinds of lists can receive content by e-mail. If you plan to enable the list to receive content by e-mail, you can add the e-mail address of the list to its description so that people can easily find the e-mail address. You can change the description for a list.

5. To add a link to the Quick Launch, verify that Yes is selected in the Navigation section.
6. If there is an E-mail section, your administrator has enabled lists on your site to receive content by e-mail. To enable people to add content to this list by sending e-mail, click Yes under Enable this list to receive e-mail. Then, in the Email address box, type the first part of the address that you want people to use for the list. This option is not available for all kinds of list.
7. Click Create.

Create a list from a page by using a list template

With SharePoint 2010 you can create lists from the pages that you are editing. This helps you more efficiently and effectively create the pages and the lists that you need.

1. From a page, click the Edit tab, and then click the Edit command.

Note If the edit command is disabled, you may not have the permissions to edit the page, contact your administrator.

2. Click on the page where you want to add a new list, click the Insert tab, and then click New List.

Note If you don't see the Edit tab or New List is disabled, you may not have the permissions that are needed to create a list; contact your administrator.

3. In the Create List dialog, type the List Tile, select the type of list that you want to create, and then click OK. Find more information about lists and related features in the See Also section.

Create a custom list

Creating a custom list resembles creating lists from a template, except that the custom list is created with only three columns: Title, Created By, and Modified By. After you create a custom list, you can add columns and make other changes to the list to meet your needs. Find more information about lists and related features in the See Also section.

1. Click Site Actions , click View All Site Content, and then click Create .

Note A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

2. Under Custom Lists, click Custom List or Custom List in Datasheet View.

Notes

• Use custom list when you primarily want to use a form to enter and view data in the list.
• Use custom list in datasheet view when you primarily want to use a grid, similar to a spreadsheet, to enter and view data in the list. This is helpful when you have several items to update at the same time. Datasheet view requires a control that is compatible with SharePoint 2010, such as Microsoft Office 2010, and ActiveX control (ActiveX control: A control, such as a check box or button that offers options to users or runs macros or scripts that automate a task. You can write macros for the control in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor.) support.
• You can change how you enter and display data in a list after a list is created.

3. Type the Name for the list. Name is required.

The name appears at the top of the list in most views, becomes part of the Web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the Web address will remain the same.

4. Type the Description for the list. Description is optional.

The description appears underneath the name in most views. Some kinds of lists can receive content by e-mail. If you plan to enable the list to receive content by e-mail, you can add the e-mail address of the list to its description so that people can easily find the e-mail address. You can change the description for a list.

5. To add a link to the Quick Launch, verify that Yes is selected in the Navigation section.
6. If there is an E-mail section, your administrator has enabled lists on your site to receive content by e-mail. To enable people to add content to this list by sending e-mail, click Yes under Enable this list to receive e-mail. Then, in the Email address box, type the first part of the address that you want people to use for the list. This option is not available for all kinds of list.
7. Click Create.

Create a list by importing a spreadsheet

You can save time creating a list by importing a spreadsheet that has the columns and data that you want for the list. Importing a spreadsheet is also a way to create a list without the default Title column.

You must use a spreadsheet program that is compatible with SharePoint 2010. The following procedure was performed with Microsoft Excel 2010. Your experience may vary if you are using a different spreadsheet program.

1. Click Site Actions , click View All Site Content, and then click Create .

Note A SharePoint site can be significantly modified. If you cannot locate an option, such as a command, button, or link, contact your administrator.

2. Under Custom Lists, click Import Spreadsheet.
3. Type the Name for the list. Name is required.

The name appears at the top of the list in most views, becomes part of the Web address for the list page, and appears in site navigation to help users find the list. You can change the name of a list, but the Web address will remain the same.

4. Type the Description for the list. Description is optional.

The description appears underneath the name in most views. Some kinds of lists can receive content by e-mail. If you plan to enable the list to receive content by e-mail, you can add the e-mail address of the list to its description so that people can easily find the e-mail address. You can change the description for a list.

5. Browse or type the File Location of the spreadsheet that you want to import and then click Import.
6. In the Import to Windows SharePoint Services list dialog, select the Range Type, in Select Range specify the range in the spreadsheet that you want to use to create your list.

Note Depending on your spreadsheet program, you may be able to select the range of cells that you want directly in the spreadsheet. A table range and a named range must already be defined in the spreadsheet to be able to select it in the Import to Windows SharePoint Services list dialog.

7. Click Import.

The types of columns that are created for a list are based on the kinds of data that are in the columns of the spreadsheet. For example, a column in the spreadsheet that contains dates will typically be a date column in the SharePoint list. The following image is the SharePoint list that was created by importing the spreadsheet in the previous image.

After you import a spreadsheet, check the columns of the list to make sure that the data was imported as you expected. For example, you may want to specify that a column contains currency instead of a number. To view or change list settings, open the list, click the List tab, and then click List Settings.

Delete a list

Use the following procedure to delete a list.

Go to the list that you want to delete.

1. Click the List tab and then click List Settings.
2. On the list settings page, click Delete this list, and then click OK.

Note If List Settings is disabled or Delete this list isn't on the list settings page, you may not have the necessary permissions to modify the settings or delete the list, contact your administrator.