WSS Lists are the ways to display information and links, because they can be added by the users from Web browsers, can be filtered and sorted on demand, and the data from lists can be inserted on multiple pages on a site.
It’s easy to convert data in a MS Office Excel spreadsheet into a WSS list.
We will take a simple example for this.
First prepare list in Excel.
Steps to convert an Excel spreadsheet to a Windows SharePoint Services list:
1) Browse to the ‘Create’ page in your SharePoint site.
2) Click on the ‘Import Spreadsheet’ link in the ‘Custom Lists’ section. It takes to the ‘New List’ page.
3) Enter the name for the list in the ‘Name’ field, and then enter a description for the list in the ‘Description’ field.
4) Click on the ‘Browse’ button. Locate the Excel spreadsheet that contains the data we want in our list, and then click on the file name, and then click on the ‘Open’ button.
5) Click on the ‘Import’ button on the ‘New List’ page. It takes to the ‘Import to Windows SharePoint Services list’ dialog box.
6) Click on the ‘Range of Cells’ option in the ‘Range Type’ drop down list.
7) Click the button on the ‘Select Range’ drop down list. It opens our Excel spreadsheet with the ‘Import to Windows SharePoint Services’ window.
8) Click and drag to highlight the areas of our spreadsheet which we want to be included in our list. (Be sure to include the column headings, they will be the field names and column titles in the list.)
9) Click on the button which is in the ‘Import to Windows SharePoint Services’ window. It opens ‘Import to Windows SharePoint Services list’ dialog box.
10) Click on the ‘Import’ button. List is created.
|
No responses found. Be the first to respond and make money from revenue sharing program.
|