I have a basic setup range in Excel like so:

In reality, its more complex, but lets use the above as an example. I have formulas inside the first column which I want to leave empty so it can be copied to the right when new entries are added.

Please note: I am not able to change the structure too much of this sheet due to internal requirements.

What I want to do is block people from inputting any data/deleting the first blank column.

So far, I’ve tried this, which almost worked, but I can’t seem to enable users to be able to use the “Delete” function.

Steps to protect range:

• Select entire worksheet, format cells, protection tab, unselect “Locked”
• Select range to protect, format cells, protection tab, select “Locked”
• Go to “Review” tab, select “Protect Sheet”, give all options including “Delete columns/rows” and activate (I’ve tried with and without password, but I need it to have no password and I can’t use VBA)
• This allows users to copy the blank range and paste it as I wanted and edit other cells, but the “Delete” button is greyed out no matter where I select.

How I protect just this empty range and/or allow deletion of cells on protected sheet?

Note: I can’t use VBA, but I’m open to alternative methods of protection