By Shekhar1205 on Tuesday, 03 January 2023
Posted in Kutools for Excel
Replies 3
Likes 0
Views 3.8K
Votes 0
Hi,

In my Kutools, the utility 'Paste to Visible' is not working. I need to paste some values against a list of filtered websites. However, whenever I am trying to paste the values against the filtered Cell, nothing happens. I have attached a small mp4 video of the entire process I am following (attached in zip format).

Please help me resolve the issue.

Regards,
Shekhar
Hi there,

I noticed that in your video, you used a traditional copy first (this is the step you don't need), and then selected a blank cell and then ran the Paste to Visible feature.
To use the Paste to Visible feature, you should 1. select the range you want to copy, and then 2. click Range > Paste to Visible > All / Only Paste Values. At last, 3. select the location where you will paste the copied value.

If you have any further questions, please don't hesitate to ask me.

Amanda
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Amanda,

Thanks a lot for your explanation. Yes, I was trying it wrongly. By following the steps provided by you, I am able to paste to visible sells only.

Regards,
Shekhar
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Glad to help
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post