The only ways I am aware of are either:

1. Merge rows 1 and 2.

2. highlight from Row 2 to bottom of the list, then do your sort. Should
force Row 2 as your header.

3. If you just want to make the information to wrap, use wrap text or
Alt+Enter to make a second row in the same cell.

"JRD" wrote:

Is it possible to have the first 2 rows as "header rows" when sorting columns
in alphabetical order, meaning that the first two rows remain at the top,
whilst the rest of the rows get sorted?

Thanks

JD