sorting columns except first column

[pixelgecko]

In my excel files, I have several columns:

"No." "First Name" "Last Name" "Quantity" "Price" "Total"

All the columns are sortable, which is expected - however, I would like for the first column to be "unsortable", meaning - suppose I sort the list by last name, I still want the numbers in the first column remain the same. I'm hoping this makes sense.

Basically, I don't want the "No." column to be sorted (I want the numbers in the column to remain the same no matter how the other columns are sorted), but all the other columns I'd like to be able to sort. Is this possible?

Thanks in advance.

 

[VoG]

If you just select the "First Name" "Last Name" "Quantity" "Price" "Total" columns before sorting, the "No." column won't be sorted.

 

[pixelgecko]

Unless I'm missing something, that doesn't seem to work. I selected the "First Name" "Last Name" "Quantity" "Price" "Total" columns, and then clicked the filter button (is that what I'm supposed to do?), but the data in the "No." column still gets rearranged when I sort in another column.

 

[VoG]

Cross posted [SOLVED] how do i prevent the first column in my excel file from being sorted?