You just need to select the unused columns > right click delete and then unused rows > right click delete


for example on the 'Apple date & ginger chutney' worksheet select column H, press ctrl & shift, right arrow (all columns will be selected) then right click and delete. For rows select row 23, ctrl & shift, down arrow (all rows will be selected) then right click delete.



That is all the macro is doing, but all all sheets, much faster than we can so manually