Hi

If I applied the auto filter across all headings but only used it on the
first heading in A1.

This is strange as I have a spreadsheet which I have done this too and all
the data has become muddled up. Im sure its because of the freeze panes and
the filters.

"Jacob Skaria" wrote:

'Autofilter' will work as normal..

Freeze panes allows you to lock specific rows and columns so that they will
always be visible on screen no matter how far you scroll to the right or down
useful especially when working with large spreadsheets..

If this post helps click Yes
---------------
Jacob Skaria


"Dave" wrote:

Hi. I am probably answering my own problem but can someone tell me if the
following is true:

If you have a spreadsheet and you freeze panes say on B2 so that the
headings in A1,B1,C1.D1 ETC and row title in
column A:A are frozen and then place a filter on column A:A will the data
IN b2 onwards remain in the same position i.e not with the filter.

Hope this explains what I am getting at. Can anyone help?