Allow setting the Default for "My data has headers"

Question

I frequently sort in Excel.  It is very rare that I sort using a header row.  PLEASE, PLEASE, PLEASE give us an option that makes no assumptions on my behalf.  Let me set it to not include a header row unless I specifically tell it to.  No macros.  No special key combinations.  No tricks like blank lines or special formatting.  Allow me to turn it off unless I select it.  Predictable behavior would be much superior to what has been implemented.

I'm sure that there will be others that want exactly the opposite - always on.  Other people will want exactly what Microsoft guessed everyone wants.  Give us a choice instead of forcing us to live with that guess.  Microsoft should evaluate that last sentence every time it thinks it knows what everyone wants.  "If the customer wants vanilla, give them vanilla!"

Make this option available as a patch for every version for which Microsoft is still providing patches.

Answer 1

The best place to make suggestions for changes / improvements to Excel is not here, but http://excel.uservoice.com

If you get enough support for your suggestion from other users the product team will consider it for future inclusion in the product (though it is less likely they will retrofit it to earlier versions).