filtered pasting
 

I'm trying to paste a row of formulas down a list, but in filtered mode.
Problem is that it's pasting into the lines that are not visible in the
filter (those that are hidden). I thought that at one point in my past, I
was pasting things and it respected the visibility factor of the filter (in
other words, only pasting into those lines that were seen). I turned
calculation to manual for ease of use (large list, pivots, etc), but I
cannot imagine that has anything to do with it. Is there some other setting,
or some particular way I have to do this (obviously aside from ctrl-selecting
each line individually and skipping over the hidden rows, which is not an
option with the number of lines I have.

Thx for any help

--
Boris

filtered pasting
 

You have a reply at your other post in .misc.

BorisS wrote:

I'm trying to paste a row of formulas down a list, but in filtered mode.
Problem is that it's pasting into the lines that are not visible in the
filter (those that are hidden). I thought that at one point in my past, I
was pasting things and it respected the visibility factor of the filter (in
other words, only pasting into those lines that were seen). I turned
calculation to manual for ease of use (large list, pivots, etc), but I
cannot imagine that has anything to do with it. Is there some other setting,
or some particular way I have to do this (obviously aside from ctrl-selecting
each line individually and skipping over the hidden rows, which is not an
option with the number of lines I have.

Thx for any help

--
Boris

--

Dave Peterson