Pasting into Filtered cells affects other cells also

Hi Forum,

Usually if I filter and perform some kind of operation on the cells displayed by the filter it is only these cells affected. For example, if I run a filter that shows 10 rows and I Paste a value into say, Column A, of all 10 Rows then remove the filter and look through all my rows, only the 10 cells displayed during the filter contain whatever I Pasted in.

However, sometimes when I do this many rows that were not displayed as part of the filter are affected. For example, I Paste something into my 10 filtered Rows and after removing my filter I find that whatever was Pasted into the 10 cells is now in 200 cells.

Why does this happen sometimes? How can I be sure that any changes I make to a set of filtered cells are ONLY applied to those cells?

Thanks very much

Dave

Hi,

Thanks for the reply, but I am not having an issue copying filtered cells. It is Pasting something into the filtered cells that is a problem (but only occasionally for some reason, usually it works fine). After removing the filter the value Pasted into the cells displayed by the filter has been pasted into many other cells as well (that where not visible when the filter was run). Why does this happen sometimes?

Also, when I did try your suggestion, when I pressed Alt+ it tries to put a Subtotal formula in?

Thanks

Dave

Hi,

I have played around a bit and found that the problem seems to occur when pasting into filtered cells using Paste Special, values (i.e, copying a formula and pasting in hard values using Paste Special, Values) and when using Format Painter to change the format of cells that have been filtered.

I now avoid these operations on filtered data.

Thanks

Dave