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.