How to Create a DataSheet View on a List in SharePoint 2010
In this blog post I will create a Datasheet View on a list in SharePoint 2010. Datasheet Views are very powerful and allow for quick data entry. You can even cut and paste from an Excel spreadsheet into a Datasheet View. If you have the 64 bit version of the Office 2010 programs installed on your client machine, the Datasheet View won't work without a hot fix. I have a bare metal dev server with SharePoint 2010 and Office 2010 installed.
In this example, I have a Site Collection with the Team Site as the Top Level Site and I have a list of some of the current courses offered at Interface Technical Training. I want to add some more courses quickly by copying them from a spreadsheet. To do this, I will create a Datasheet View. In this blog, I'll just show the part of creating the Datasheet View.
This will change the ribbon to be contextual to interacting with the actual list as a container, which is where you create the views.
Datasheet View is very similar to Access View but occurs entirely in the browser and is a great tool for rapid data entry.
I name the view QuickEdit-DSV (I like to use DS or DSV in my Datasheet View Names) and configure the columns as needed. In this case SharePoint guessed correctly.
To add some data from a spreadsheet, I would simply scroll to the bottom and choose a cell and paste in the data. Of course the columns have to match up.
That's it!
Spike Xavier
SharePoint Instructor – Interface Technical Training
Phoenix, AZ
Creating Users and Managing Passwords in Microsoft Office 365
In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365. For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365
Using Navigation Controls in a Collaboration Site in SharePoint
In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint
Detailed Forensic Investigation of Malware Infections – April 21, 2015
How does an investigator hunt down and identify unknown malware? In this recording of our IT Security training webinar on April 21, 2015, Security expert Mike Danseglio (CISSP / CEH) performed several malware investigations on infected computers and identify symptoms, find root cause, and follow the leads to determine what’s happening. He demonstrated his preferred … Continue reading Detailed Forensic Investigation of Malware Infections – April 21, 2015
Write a Comment
