Excel doesn't sort columns if there is a blank column in between

If you try to sort on a column when there is a blank column, only the columns before the column will be sorted. How can this be changed so that all columns are sorted regardless of whether there are any blank columns?