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
I just tried the steps below and go the below error message:
What might I be doing wrong? Thanks.
I just tried to do the same steps and got the same error message. It would seem that this is a bug in the software.
Excel shows a count of 25 items when I select the values to copy. When I filter the 25 cells I want to paste into, the count is 25. Even though I have used the "Go to, special, visible cells", it still won't let me paste into those 25 cells.
Other users have reported this inconsistency in software behavior here:
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/34651030-ability-to-paste-to-filtered-visible-cells