Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Sorting

Thanks Jacob.

I misread 1st as last.



Jacob Skaria wrote:

Select the option 'My Data Range has header row'

If this post helps click Yes
---------------
Jacob Skaria

"Dave Peterson" wrote:

Select the range to sort first--Avoid selecting the last row.

Then sort the selection.

I never let excel guess at the range to sort. I don't trust it.

Larry C wrote:

How do I exempt the 1st row from sorting?


--

Dave Peterson


--

Dave Peterson