Lock Columns A, B & C, but Still Allow Rows to be Added or Deleted

[Dmichaud61]

Greeting - is it possible to just lock columns A, B & C from being edited, but still allow rows to be added or deleted? I using Excel 2016.
Many thanks in advance for any assistance.

 

[jmacleary]

Hello. Yes. Set columns A to C as locked, then click Protect Sheet. There is an option you can check (click) to allow Insert Rows. You will have to also check Select Locked Cells and Select Unlocked Cells.

 

[Fluff]

Whilst you can insert rows, you cannot delete them if you have locked a column.

 

[Dmichaud61]

Thank - your solution worked.