Protect Excel sheet but allow insert/ delete of rows and/ or columns

Share this & earn $10
Published at : September 24, 2021

00:00 Protect cells and ALLOW inserting/ deleting rows/ columns (NOT RECOMMENDED)
00:08 Insert rows disabled
00:26 Set up sheet to allow insertion and deletion of rows and/ or columns

How to protect an Excel sheet in such a way that formulas cannot be changed but you still allow the user to insert of delete rows and/ or columns. Generally inserting and deleting are the main cause of problems so this is not recommended unless you are sure about it. Protect Excel sheet but allow insert/ delete of rows and/ or columns
cannot insert row in excelcant insert column in excelexcel insert row disabled