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
Richard2244
Nov 24, 2020Copper Contributor
As others have stated, Excel does not allow you to paste into a filtered data. The best way to do this is to sort instead of filter. The easiest way to do this, especially for information that is not easily sortable, is to:
- filter your info
- fill the cells of your filtered list with a color
- Clear the filter
- do a custom sort of the list by color and then by a-z (to make it match up with the information you are pasting in)
- Paste your information in your sheet
- Reorder the colors from your cells and reorder the information if necessary.
Note: If the original order of your information is important, do what one user suggested and add a column to your original sheet and number each row, so you can resort back to its original order.
Also, if you are working with extremely large lists where you first have to identify the matching cells before copying over the information, you can always use conditional formatting to identify and highlight any matching cells in a column from one sheet to another within the same workbook. After doing this, you can then follow the steps above to copy the information over.
- FateSOct 22, 2021Copper ContributorThis worked for me perfectly! Thanks!