Just a guess...

Do you use merged cells in this data?

And you've autofit the columnwidths, right?

What version of excel are you using?

Piglet99 wrote:

It does have headers, the file was an imported DAT file. There are
Autofilters on some apparently blank columns - which I believe are due to
spaces being present in the DAT file. However if we filter on, say column K
the blue filter arrow appears on column G.

"Stefi" wrote:

Do you have a header in each column? Autofilter is sensitive to the absence
of headers!

Regards,
Stefi

€žPiglet99€� ezt Ã*rta:

We have a spreadsheet with Autofilters on. when you select a column to
filter the blue arrow appears on another column which is not the one filtered
on. We have reinstalled Excel but this has not cured the problem, does
anyone have any ideas as to why it seems to have gone insane?

--

Dave Peterson