Deleting cells won't prompt me to shift row or column up, down, left or right

I've attached the sheet I'm working with. I need to delete most of column F and shift the rows to the left, but when I delete the cells it doesn't give me a prompt to shift the row, it just deletes the entire column or individual row. I need them to shift, what can I do?

As you have set both your sheets as tables (Table13 and Table14) you can't delete individual cells to do so you need to remove the table setting first.

Alf

Thankyouthankyouthankyou!