x404.co.uk
http://www.x404.co.uk/forum/

Excel irritation
http://www.x404.co.uk/forum/viewtopic.php?f=3&t=19325		 Page 1 of 1
Author:  Spreadie [ Fri Jul 05, 2013 9:09 am ]
Post subject:  Excel irritation
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.`
Author:  AlunD [ Fri Jul 05, 2013 9:13 am ]
Post subject:  Re: Excel irritation
There is an option when setting the filters to use row 1 as a header or not

what version of excel is it?
Author:  Spreadie [ Fri Jul 05, 2013 9:18 am ]
Post subject:  Re: Excel irritation
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.
Author:  AlunD [ Fri Jul 05, 2013 9:22 am ]
Post subject:  Re: Excel irritation
no problem :D
Author:  big_D [ Sat Jul 06, 2013 9:04 am ]
Post subject:  Re: Excel irritation
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.
Author:  Spreadie [ Sat Jul 06, 2013 5:53 pm ]
Post subject:  Re: Excel irritation
big_D wrote:
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.
Author:  Amnesia10 [ Sat Jul 06, 2013 9:55 pm ]
Post subject:  Re: Excel irritation
Spreadie wrote:
big_D wrote:
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.
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/