Locking columns containing formulas but being able to select & delete rows

Hello,

Please see attached Workbook (in .xlsx format).

Just in the "Data" sheet, I have highlighted in YELLOW the columns that contain formulas that I want to protect. Note that there are columns selected that are as far to the right as columns AP to AS.

I would like to be able to Protect those columns BUT also be able to select a row of Data and delete the data from that row (eg. Shift up the rows below) & still have the data in those protected rows(containing formulas).

Is there a way I can do that?

Thanks
Trent