How to delete rows and columns only if rows &/columns are entirely blank?

if i am using “go to special” and select “blank” even the rows & / columns which are having data except in 1 cells are also deleted. so i am in trouble. so i want an option which deletes any rows/column only if they are completely blank.