EXCEL: How to Turn the Heading Row “On” or “Off”

When we work in Excel (Spreadsheets) whether for numbers or data management, it's always best to be sure that we've typed in a heading row, so that when we sort a column - it will be easier to understand the meaning of the data. By default, the value in the heading is not included in the sort operation.

 

Occasionally, you may need to turn on or off the heading so that the value in the heading is or is not included in the sort operation. Do one of the following:

• To exclude the first row of data from the sort because it is a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort, and then select My data has headers.
• To include the first row of data in the sort because it is not a column heading, on the Home tab, in the Editing group, click Sort & Filter, click Custom Sort, and then clear My data has headers.