View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default sort, 2 row header

"Kath" wrote:
I would like to preserve 2 rows for headers (don't want to merge cells,
or use alt-enter to put text on two lines). How do I sort and preserve
these 2 (or more) row headers?


Try selecting only the data rows (below the headers)
then Data Sort Check "No header row"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---