SharePoint DIY

Main navigation

  • ← Creating Task Lists for Tracking
  • Using Views within SharePoint Lists →

Using Datasheet View for Lists

Posted on Apr 27, 2009 by admin

Datasheet view exposes list in a format that we are familiar with……Excel.  You can easily label rows and columns just like a spreadsheet as well as enter in any information you need for your list.
To create a list in Datasheet view, do the following:
Click Site Actions >> Create.
Under Custom Lists, choose Custom List in Datasheet View.
 
As usual give your list a name, description, and choose whether you would like it displayed in the Quick Launch bar.
Click Create.  SharePoint immediately takes you to your list to start entering some data.  Start entering data just as you would on a spreadsheet.
 
If you need to add a column to this list, click the Settings dropdown and choose Create Column.

  
This will take you to the Create Column screen that was discussed in previous blogs.  Simply fill in the appropriate information for your column and click OK.
If you would ever like to exit Datasheet View, go to the Actions dropdown and select Show in Standard View.  This will bring you back to the common view used to create other lists.
 
This is just another way to get data entered into SharePoint.  Choosing Standard View as opposed to Datasheet View is simply a matter of preference of the user.  Both will accomplish the same goal.

Category: Articles, Tutorials

top ^

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Recent Posts

  • Create a nicer looking hyperlink instead of the full URL using simple HTML
  • “The template you have chosen is invalid or cannot be found” – Solution
  • Making the “Encoded absolute URL” work with a list in SharePoint
  • Export a SharePoint site as a Site Template (.stp file)
  • Upload and use a site template (.stp) in SharePoint

Recent Comments

  • RYAN on Add a new subsite using SharePoint Designer
  • JAMES on “The template you have chosen is invalid or cannot be found” – Solution
  • SEAN on The paste text dialog box
  • Webmaster on Security settings for a subsite
  • morison dony on Export a SharePoint site as a Site Template (.stp file)

Archives

  • June 2009
  • May 2009
  • April 2009
  • March 2009
  • February 2009

Categories

  • Articles
  • Featured
  • Tutorials

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org

Go Metal Detecting!

Check it out: The Best Metal Detector Store @ Serious Metal Detecting


  • Adventure Metal Detectors
  • Treasure Metal Detectors
  • Gold Metal Detectors

Minelab E-TRAC for sale at Serious Detecting

Tags

HTML MOSS Outlook SharePoint Designer Workflow WSS

Categories

  • Articles
  • Featured
  • Tutorials

Search

SharePoint DIY | Copyright SharePoint DIY