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.
|