Freeze Panes
Hi,
No the data will change with the filter, I check it since I wasn't sure
if this helps please click yes, thanks
"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?
|