Insert empty columns in list w/o header

[purplec0ws]

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.

 

[Gord Dibben]

Select all columns before hitting Sort

Do not let Excel guess what the range should be.


Gord Dibben MS Excel MVP

 

[purplec0ws]

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.