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 Here's what I follow:
1. Cut+paste the rows (for which you want to paste the values) into a new sheet.
2. You will now be able to simply copy+paste the required values into this new sheet.
3. Copy the data from the new sheet back into the original sheet
4. Adjust the sorting as required.
PS: If the original data is not sorted on any column and you want to retain that original order, you can add a column to remember the sequence of rows (1, 2, 3...), which can they be sorted by to get the original order back.
