Forum Discussion
NSK-Mar
Nov 17, 2019Copper Contributor
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
siladityac
Oct 05, 2023Copper Contributor
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.
kakaitou
Feb 21, 2024Copper Contributor
Alhamdulillaah.. thank you, your solution help me solve my problem with copy-paste in filtered view..
- siladityacFeb 23, 2024Copper ContributorGlad it helped 🙂