Excel Functions and Formulas

Trick: Protect rows and columns without protecting sheet

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

 

0 of 105 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop