Are you sure there are no functions that can "mass apply" to only the
filtered portion of a list? I could have sworn I've done that before.
--
Boris


"Dave Peterson" wrote:

Excel doesn't have anything that lets you do this built into it.

But maybe you could sort your data, then paste into that contiguous range.

Then resort and reapply the filter???

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 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, which is not an option with the number
of lines I have.

Thx for any help
--
Boris

--

Dave Peterson