![]() You can change the description for a list.īrowse or enter the File Location of the spreadsheet that you want to import, and then select Import. The description appears underneath the name in most views. You can change the name of a list at any time, but the web address will remain the same.Įnter the Description for the list. 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. In SharePoint 2007, under Custom Lists, select Import Spreadsheet, and then select Create.Įnter the Name for the list. In SharePoint 2010, under All Categories, select Blanks & Custom, select Import Spreadsheet, and then select Create. If you cannot locate an option, such as a command, button, or link, contact your administrator. ![]() Note: A SharePoint site can be significantly modified. The spreadsheet data appears in a list in SharePoint. To view or change list settings, open the list, select the List tab or select Settings, and then select List Settings. For example, you may want to specify that a column contains currency instead of a number. Select Import.Īfter you import a spreadsheet, check the columns of the list to make sure that the data was imported as you expected. The range appears in the Select Range field. ![]() In the spreadsheet, select the upper left cell, hold down the Shift key, and select the lower right cell of the range you want. If you want to select a range manually, select Range of Cells, and then select Select Range. In the Import to Windows SharePoint Services List window, select Table Range, Range of Cells, or Named Range. The spreadsheet opens in Excel, and the Import to Windows SharePoint Services List window appears. You can change the description for a list at any time using list settings.īrowse to or enter the File location of the spreadsheet. You can change the name of a list, but the web address will remain the same. 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. In the New app page, enter a Name for the list. In the search results page, select Import Spreadsheet. In the Find an app field, enter spreadsheet, and then select the search icon. On the site where you want to add a spreadsheet based list, select Settings, and then select Add an app. However, you can still achieve the same thing by exporting data to SharePoint from Excel, as described in Export an Excel table to SharePoint. Note: When you're using a site template, it is no longer possible within SharePoint to create a list from an Excel workbook.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |