Trick: Protect rows and columns without protecting sheet

Please purchase the course before starting the lesson.

The problem with the Protect Sheets is that it does apply some limits and some users want everything to be open EXCEPT that they don’t want users to insert or delete rows and columns (this is a very common cause of spreadsheet errors or ‘templates’ corrupting). This is a trick to disable the insert/ delete option without protecting the sheet and no VBA.

 

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