I have imported an excel document into SharePoint 2010. One of the columns was automatically defined as being multi-line, but I want it to be single line input instead. I have looked at redefining the column as single line but I am not presented with the option to do so. How can I overcome this problem and redefine the column (without losing all the data associated with it)?

1 Answer 1


You cannot change it. I think You have two (more or less bad) options.

  • Delete the column (and then lose the information in it) and create it again with the correct properties.


  • Rename the column and create a new (with the name of the old and set it to Single Line). Copy the Content from the "renamed" column into the new.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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