I have a table in Excel approx 350 rows by 16 columns. Each column is named and, usually, to filter the table by a given column, I click on the second cell in that column and sort by A to Z.

This normally leaves the column names at the top of the table - but today it has decided to include row 1 in the sorting process, leaving the column headers halfway down the table.

What am I missing? Is there a simple setting somewhere? I'm not talking about freezing panes and such, it was never necessary before (and doesn't work in this instance anyway).

Please show compassion and help a dunce today.`

There is an option when setting the filters to use row 1 as a header or not

what version of excel is it?

Got it! - "my Data has headers"

I don't understand why I had to turn that on - it's always been on by default in the past. Still - at least I know now.

Thanks, Alun, I appreciate it.

no problem

Excel tries to intelligently look at the data you are sorting and if it can discern headers, it will automatically use them. If it can't work it out, it will assume there are no headers.

If a column "header" is blank or just a number, it will generally assume that there are no headers. Duplicate column names can also confuse it, I believe.

I sort the same table every quarter, and this is the first time Excel behaved that way.

There was a update to Office recently for mac could there have been an update for the Windows version?


Sent from my iPad using Tapatalk.