Problem
When pasting copied information into the Comment field in a Questionnaire template, a dialogue indicates that the cell is protected:
Cause
Questionnaire templates are protected to ensure the core formatting is not corrupt by formatting that could be accidentally copied from an external source.
Solution
There are several solutions to this problem.
Solution 1
Use Paste Special and select only text
Solution 2
Select the cell and paste the text into the Formula bar at the top of the sheet:
Solution 3
Double click in the cell until you see the cursor flashing. From there, Paste Special and select text as above.
Comments
Article is closed for comments.