ExcelBanter - how do i copy formula down columns avoiding hidden cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do i copy formula down columns avoiding hidden cells (https://www.excelbanter.com/excel-discussion-misc-queries/50429-how-do-i-copy-formula-down-columns-avoiding-hidden-cells.html)

PETE

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.

Stefi

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.

All times are GMT +1. The time now is 08:49 PM.