Insert empty columns in list w/o header

  • Thread starter Thread starter purplec0ws
  • Start date Start date
P

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.
 
Select all columns before hitting Sort

Do not let Excel guess what the range should be.


Gord Dibben MS Excel MVP
 
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.
 
Back
Top