Thread: text to colems
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
 
Posts: 268
Default text to colems

Click on Data Sort, select has header row, and then sort

"Sparky AKA_Sparkticus" wrote:

i have a sheet with data i want to sort, i can lock the top row as an header
and select the columns i wish to sort without the header changing but is
there a way so that if you select the whole worksheet it still locks the
column header i have on row 1

sparky