Sorting

[Larry C]

How do I exempt the 1st row from sorting?

 

[Dave Peterson]

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.

 

[Jacob Skaria]

Select the option 'My Data Range has header row'

If this post helps click Yes

 

[Dave Peterson]

Thanks Jacob.

I misread 1st as last.

Select the option 'My Data Range has header row'

If this post helps click Yes