View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tryer
 
Posts: n/a
Default how can I sort with header not on row 1


Hi,
I would like to sort 'by header' when the headers are on row 5. I know
that I can highlight all the rows from 5 to bottom of the sheet
manually then sort by header row but with a large sheet this is time
consuming. I would like to select the entire sheet and then sort by
header(on row 5)
Is this possible?


--
tryer
------------------------------------------------------------------------
tryer's Profile: http://www.excelforum.com/member.php...o&userid=16546
View this thread: http://www.excelforum.com/showthread...hreadid=528692