View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
dlw dlw is offline
external usenet poster
 
Posts: 510
Default how do I sort rows by the contents of one cell

yes, select all the rows, click on heading A, hold shift key down and click
on the last column
or just click on the blank square up in the corner between A and 1, that
selects everything

"bhaight58" wrote:

I have a large worksheet that has multiple coulmns of data, in different
formats.
The problem is I need to sort decending based on just one coulmn. however
when I try to do that it just moves that single coulmn around. is there any
way to "lock" the row together and then let me adjust by the data in that
coulmn?
thanks