Data Sort header row
 

I would like to have default Header Row checked when I click on Data
Sort.
Are there any option to set it?

I got randomly sometimes checked Header Row, but sometime No Header
Row.

Your information is great appreciated,

Data Sort header row
 

Excel tries to guess whether the first row contains headers...

For the first row to qualify as header the first row should have -
text in all cells &
no blank cells

"inungh" wrote:

I would like to have default Header Row checked when I click on Data
Sort.
Are there any option to set it?

I got randomly sometimes checked Header Row, but sometime No Header
Row.

Your information is great appreciated,