Forum Discussion
Paste TO visible cells only in a filtered cells only
Hello NSK-Mar
- copy the formula or value to the clipboard
- select the filtered column
- hit F5 or Ctrl+G to open the Go To dialog
- Click Special
- click "Visible cells only" and OK
- hit Ctrl+V to paste.
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
DanNow The steps I described only work when you paste a single item into multiple cells. As the error message says, if you have several items selected, the target of the paste must be the same shape as the source.
In this case you may need to sort your source table so you can select the data as one contiguous range, then sort the target table and paste as one contiguous rang there, too.
- Its not working. kindly guide through video
If anyone still has problem with this, please check out this article:
https://www.mrexcel.com/board/threads/excel-vba-easy-way-to-paste-to-visible-cells.1239792/
it shows you how to make copy-paste visible cells functionality available in any open workbook.
IngeborgHawighorst Thanks for responding. Yes, that is the difficulty; the target table was not easily sorted into one contiguous rang. That said, I just used some vlookups to help me transfer the data from the source file to the destination file. It is a shame that there isn't a way to inform Excel that the pasted data should only be deposited into visible cells. Have a good one.
