Lock Cells but allow insert or delete of columns/ rows

Please purchase the course before starting the lesson.

We find that most problems are caused by users inserting or deleting rows and columns when this is not allowed, so we normally don’t allow this option. But if you want to lock cells but allow insert or delete of columns/ rows then this is the way to do it.

 

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