Lock Cells but allow insert or delete of columns/ rows

Preview
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




Lesson tags: vlookup
Back to: POPIA and GDPR Compliance- Built in Excel Tools that will help > Making protected Excel Spreadsheets easier to use