View Single Post
  #2  
Old 10th June 2005, 03:38 PM
laish laish is offline
Member
 
Join Date: Jan 1970
Posts: 31
Smile Excel fixit

OK, Dalray it is not to hard to get back on track with this for you. What you need to do is make sure that there are headings on ALL of your columns so as to not confuse the situation more.

Then on the left side of the screen on the row numbers highlight ALL the rows you wish to sort but do not include the row with the headings on them.

Then go to Data and choose sort, make sure the radio button of My list has : a header row is chosen. Then chose the column you wish to sort by, generally for fav it would be price and choose ascending, so it will list the row with the lowest price 1st and the dearest or least fav last.

Hopefully this will help.
Reply With Quote