SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

I have created a list using "Custom List in Data Sheet View". After that I created around 10 columns in that list. Problem is only for one column, it is showing as read only, rest all are working fine!! Hence I cannot insert a row in the list(Data sheet view).

How can I remove that read only attribute from the column?

One more related question is, how to make the list editable to only one group and read only to other groups?

Thank you, for your valuable inputs!!

share|improve this question
There is the same problem in this quection (with answear) -… – Alex Lee Jan 21 '14 at 7:16
up vote 2 down vote accepted

You should go to list tab on the ribbon, then open list permissions settings. In this settings you can add two groups (or use existed groups) and set Read rights for one group and Contribute rights for another. By default the list inherits permission from a site. You can broke this relationship by Stop inheriting permission button.

what type of this field?

share|improve this answer
Thank you Alex for your help, the permission link just worked great!! other regarding the column (Type is plain text)it shows read only, also the attachment column also shows read only !! Some help please !! – Jithu Nov 2 '11 at 7:00
I have not got any ideas :( – Alexander Nov 2 '11 at 7:59
That's fine I just re edited, one of the column, and the read only option has just gone.. Though the attachment column has it even now!! Thanks! – Jithu Nov 2 '11 at 8:07

I had a very similar issue. I'd added a Rich Text column for notes to an existing list. I could add text to the Notes field if I opened each list item and edited individually but edits to that field when in Datasheet View were met with "the selected cells are Read-Only".

I simply altered the rich text format to be plain text and it cleared up the issue.

share|improve this answer

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.