Insert empty columns in list w/o header
 

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.

Insert empty columns in list w/o header
 

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.

Insert empty columns in list w/o header
 

I created a list so there are drop down menus at every column of the header.
If I restrict the selection, I only get drop down menus on the restricted
selection. However, I need drop down menus on random columns throughout my
range.

"Gord Dibben" wrote:

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.