View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to sort when I have multiple header rows (not included in sor.

Select your range to sort first--don't include the headers.

Then use Data|sort and specify that the selection doesn't include headers.

K_Millan wrote:

I have a spreadsheet with three rows of "header" information (Section title,
Column title, Column total). How do I sort (A to Z) without including the top
3 rows in the sort? Thanks!


--

Dave Peterson