Custom List in Datasheet View in SharePoint 2010

Introduction

Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.

Question:
 What is a Custom List in Datasheet View?

In simple terms "The list is displayed as an Excel spreadsheet which is easy to create and manage the data".


I think we are now good to go and implement this wonderful concept.
 

 

Step 1: Open SharePoint 2010 Central Administration and navigate to a specific site:

 

Output1.jpg
 

 

Step 2: Navigate to "Site Actions" ->   "More Options...":

 

Output2.png

 

Step 3: Select "Custom List in Datasheet View" from the listed categories. Give a name to the list:

 

Output3.jpg
 

Step 4: The custom list in datasheet view is now created; the site now looks like this:

 

Output4.png
 

Step 5: Create new columns for the first name, last name, gender and age:

 

Output5.png


 

Output6.png
 

Output7.png
 

Output8.png

 

Step 6: Rearrange the view according to the user's prefered fashion:

 

Output9.png
 

 

Step 7: Data has been added to the list; the site now looks like this:

 

Output10.png
 

 

 I hope this article is useful for you.


MVC Corporation
MVC Corporation is consulting and IT services based company.