Simple steps to set the first row title in Excel not to participate in sorting

Troubled by whether the first row title of Excel is involved in sorting? PHP editor Yuzai brings you simple and clear solution steps. Follow our guide to easily set headers out of sort and keep your data organized!

Select a set of data to be sorted.

Click [Sort or Filter] and select [Custom Sort].

Or click [Data], [Sort].

[Data contains title] is checked, that is, the first row defaults to the title.

Remove the check mark before [Data contains titles], and the first row will participate in the sorting

Select [Select ascending or descending order], and then click [ Sure】.

Note:

When sorting, if the title and data are selected together, you should check [data contains title], otherwise the title will also be sorted together. .

The above is the detailed content of Simple steps to set the first row title in Excel not to participate in sorting. For more information, please follow other related articles on the PHP Chinese website!