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
Step 1: Select both the filtered source column and destination column
Step 2: Go to Home->Editing->Fill and select the direction of fill from source to destination column. The source and destination column doesn't need to be adjacent.
For people having this problem in the future: After selecting the filtered source column and destination column at the same time, use alt+; / option+; to select visible cell only. Then use fill and select the direction e.g. right.