View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Don't just select a single column before you sort.

Select the whole range (all 10 columns), then do data|sort.

S.J.Michael wrote:

I have a worksheet with 10 columns for various information per row per
customer. I need to sort the rows at times and need the columns to stay with
the rows. Is there a way to lock them? Thanks for help.


--

Dave Peterson