sorting columns except first column

pixelgecko

New Member
Joined
Sep 6, 2013
Messages
2
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.
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
If you just select the "First Name" "Last Name" "Quantity" "Price" "Total" columns before sorting, the "No." column won't be sorted.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,061
Messages
6,169,873
Members
452,287
Latest member
winnievmex

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top