Lock cells but allow colour formatting or comments

Please purchase the course before starting the lesson.

You can lock cells but allow colour formatting or comments which don’t affect the security of the formula but allow a user to provide some sort of feedback to you. Note that adding comments is different from formatting so it requires a different setting.

Lock cells but allow colour formatting or comments

 

To see the full course contents click here.

Lesson tags: vlookup
Back to: Advanced Excel Course > Protecting spreadsheet information and formulas