View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How can I keep more than one row from sorting

Select the range of cells you want to sort before you issue the sort
command. Don't let Excel guess which cells you want to include.
--
David Biddulph

"Ryle" wrote in message
...
I have two Header rows that I would like to avoid combinning and need to
stay
frozen when I sort. As it is now both rows with stay on top as I scroll
through the document but when I sort the second one is sorted into the
rest
of the document.