Select all columns before hitting Sort

Do not let Excel guess what the range should be.


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 08:35:01 -0700, purplec0ws
wrote:

I have a list with about 10 columns of data, but I only want the data to be
able to sort of just 3 of the columns. The 3 columns are spread throughout
the table.

If I try sorting without creating a list, the filter only sorts the data in
the column, but I need all the rows to filter with that column.