Making protected Excel Spreadsheets easier to use

Lock Cells but allow insert or delete of columns/ rows

This is a preview lesson
Register or sign in to take this lesson.
Note: All Excel protection is relatively weak. It is useful to stop casual users but it is not for top secret information.

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.

To follow along go to 19.4

In order to allow the insertion or deletion of columns and rows on a protected sheet you will need to tick some/ all of the options highlighted below

Lock Cells but allow insert or delete of columns/ rows