How do I exempt the 1st row from sorting?

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

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

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