SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way to disable just few of the columns in Datasheet view? I would like to show all the columns, but to allow the clients to edit only some of them, and in order to prevent any mistakes, to disable the others?

Thanks. BN

share|improve this question

You can define your "read only" columns as rich text fields. These columns cannot be edited in the datasheet view. If you're into programming you can create your own custom field types (like custom number, currency...) Custom field types cannot be edited in the datasheet view either.

share|improve this answer
In SharePoint 2010, this works for ENHANCED rich text fields, not regular rich text fields. – Wendy Feb 23 at 15:46

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.