Tools|Options|Custom Lists tab
Add your High, Medium, Low

Then you can sort by this custom list.

Then select your range
(make this field the first sort field)
data|sort|options
choose your High, Medium, Low list for the sort order.



Aravind wrote:

I have a column with priority list High, low and medium. I need to sort the
whole excel sheet according to that column. or priority list. Is it possible?
Can anyone give me advice.

--

Dave Peterson