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

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

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

I just tried it with a simple set of rows outside of that sheet. Basically
did an OR on the filter to where I specifically ended up with the two rows
which were on the top and bottom of the range of rows. Applied a formula to
the shown cells (highlighting straight through, so in theory "including" the
hidden rows). When I took off the filter, the rows that were hiddend did not
have that formula applied. So at least I proved to myself that I wasn't, in
this case, crazy for thinking I'd done it before.

Now the question is why a particular sheet would NOT apply that logic, and
would write formulas into the hidden rows that were filtered out.

--
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

I think that there is a difference between pasting a copied range and entering a
formula like you did.



BorisS wrote:

I just tried it with a simple set of rows outside of that sheet. Basically
did an OR on the filter to where I specifically ended up with the two rows
which were on the top and bottom of the range of rows. Applied a formula to
the shown cells (highlighting straight through, so in theory "including" the
hidden rows). When I took off the filter, the rows that were hiddend did not
have that formula applied. So at least I proved to myself that I wasn't, in
this case, crazy for thinking I'd done it before.

Now the question is why a particular sheet would NOT apply that logic, and
would write formulas into the hidden rows that were filtered out.

--
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


--

Dave Peterson

I was hoping you were right, and then I copied just the one cell with the
right formula, highlighted just the set of filtered cells under one column,
and it still didn't do it (in other words, overwrote hidden rows).

Any other thoughts, or something on your end you're doing that I may be
missing?

--
Boris


"Dave Peterson" wrote:

I think that there is a difference between pasting a copied range and entering a
formula like you did.



BorisS wrote:

I just tried it with a simple set of rows outside of that sheet. Basically
did an OR on the filter to where I specifically ended up with the two rows
which were on the top and bottom of the range of rows. Applied a formula to
the shown cells (highlighting straight through, so in theory "including" the
hidden rows). When I took off the filter, the rows that were hiddend did not
have that formula applied. So at least I proved to myself that I wasn't, in
this case, crazy for thinking I'd done it before.

Now the question is why a particular sheet would NOT apply that logic, and
would write formulas into the hidden rows that were filtered out.

--
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


--

Dave Peterson

Just my original suggestions to sort, copy|paste, and re-sort.

You could write a macro that cycles through each of the cell in the copied range
and pastes into the visible cells.

BorisS wrote:

I was hoping you were right, and then I copied just the one cell with the
right formula, highlighted just the set of filtered cells under one column,
and it still didn't do it (in other words, overwrote hidden rows).

Any other thoughts, or something on your end you're doing that I may be
missing?

--
Boris

"Dave Peterson" wrote:

I think that there is a difference between pasting a copied range and entering a
formula like you did.



BorisS wrote:

I just tried it with a simple set of rows outside of that sheet. Basically
did an OR on the filter to where I specifically ended up with the two rows
which were on the top and bottom of the range of rows. Applied a formula to
the shown cells (highlighting straight through, so in theory "including" the
hidden rows). When I took off the filter, the rows that were hiddend did not
have that formula applied. So at least I proved to myself that I wasn't, in
this case, crazy for thinking I'd done it before.

Now the question is why a particular sheet would NOT apply that logic, and
would write formulas into the hidden rows that were filtered out.

--
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


--

Dave Peterson


--

Dave Peterson