View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
RonaldoOneNil RonaldoOneNil is offline
external usenet poster
 
Posts: 117
Default How to sort without including column headings in sort

Don't know what version of Excel you are using but in Excel 2000 when you
select your columns and then click Data - Sort, the Sort dialog box has a
radio button at the bottom to say whether your columns have a header row or
not.

"OPDvolunteer" wrote:

I can't find the answer either online or in Excel help probably because I'm
not using correct terms. The first row contains column titles, and when I
sort the columns these titles get sorted to. Can I somehow anchor or
designate the text in these cells to remain fixed?