MS-Excel / Excel 2003

Adding List Spreadsheets to SharePoint Site home page

To make it as easy as possible for users to access the spreadsheets, you can customize the home page of the SharePoint site by adding the document library to the main content area. When you do this, all the spreadsheets saved in a particular document library are listed in this area. A team member can open any of the workbooks listed on the home page simply by clicking the link attached to the workbook's filename.

To add a document library to the main contents area of the home page, follow these steps:

  1. Log on to the home page of your SharePoint site.
  2. Click the Site Settings button on the home page toolbar.
  3. Click the Customize Home Page link in the Customization section.
    Internet Explorer returns you to the home page, which now contains an Add Web Parts task pane on the right side. (In the SharePoint world, document libraries are considered Web parts.)
  4. In the Add Web Parts task pane, find the name of the document library you want to add and then drag it to the place in the main contents area where you want it to appear.
  5. After placing the document library - along with its list of spreadsheet files - where you want it on the home page, click the Close button in the Add Web Parts task pane to get rid of it.

After adding a document library to the home page, you as the administrator can upload new spreadsheets to it by clicking its Add New Document link at the bottom of the list of its documents.

[Previous] [Contents] [Next]