how do i copy formula down columns avoiding hidden cells

hello, i need to copy a formula down a column in a spread sheet, but i need
to avoid putting it in to cells that i have filtered out.
Is this possible to do?
any help would be great.

Just fill it down through unfiltered rows and you will see that hidden rows
remain unfilled!

Regards,
Stefi


„PETE” ezt �*rta:

> hello, i need to copy a formula down a column in a spread sheet, but i need
> to avoid putting it in to cells that i have filtered out.
> Is this possible to do?
> any help would be great.