To delete entire range, you can place the delete range outside the loop.
The hotkeys might not work with excel.
The delete range properties should be supplied with the exact range and you could also alter property ShiftOption.
To do this in a loop, you need make the range dynamic (use a variable that holds the row number/column name based on the counter) and then delete that particular row/column in the loop for ‘x’ number of times.
Please share the loop actions if you need more help.