Forum Discussion
Paste TO visible cells only in a filtered cells only
I want to paste a formula or value in the visible cells of a filtered column. How to go about it? Thanks
NSK-Mar Another option would be to replicate your source column, then clear out all the values not shown in your filtered list ('reverse' the filter, then clear the values). Then remove the filter from the table altogether, copy the entire column, finally do Paste Special and select Skip Blanks.
