Skip to main content

Quickly copy data and paste to visible cells only in Excel

Kutools for Excel

Boosts Excel With 300+
Powerful Features

In Excel, when you copy and paste some data into a range which has been filtered or contains hidden rows, the data will be pasted to those filtered or hidden cells too. Can we just paste data to visible cells only in Excel? Yes, Kutools for Excel's Paste to Visible feature will help you get it done quickly.

How to paste to visible cells only

Paste To Visible Range Demo


Location of Paste to Visible: Kutools > Paste to Visible

shot paste to visible cells 01


How to paste to visible cells only

Let's say we have a filtered table as shown in the screenshot below, to replace the visible quantity values in column C with the new quantity values in column D, please do as follows:

shot-paste-to-visible-cells-2

1. Select the data that you want to copy and paste to the filtered list.

2. On Kutools tab, in Range & Cells group, please click Paste to Visible.

shot paste to visible cells 02

3. In the Paste to Visible Range prompt box, select the first cell of the range where you want to paste the selected data to, and then click the OK button.

Result: The selected data are pasted to filtered rows only immediately.


Note:
  • If you want to copy and paste values only (Not formatting and not formulas), please click Paste to Visible > Only Paste Values in step 2.

  • This utility supports undo (Ctrl + Z).
  • The feature helps you paste data to visible cells only, so, it works no matther there are filtered-out or hidden rows in your data.

Demo: copy data and paste into only visible cells / filtered list in Excel



Kutools for Excel: with more than 300 handy features, free to try with no limitation in 30 days. Download and free trial Now!


Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

 

Comments (10)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
How dynamically i paste values in another sheet without vba?
This comment was minimized by the moderator on the site
What if you have one value want to paste into multiple cells?
This comment was minimized by the moderator on the site
Then you can use the traditional copy and paste: Press Ctrl + C to copy the value, and then hold Ctrl to select multiple cell ranges, at last, press Ctrl + V to paste the value to the selected cells.

Amanda
This comment was minimized by the moderator on the site
This didn't work for me at first either. I was trying to copy and paste. But you don't copy anything. You just select the values that you want to copy - don't actually copy them and then click over to where you want them to be pasted to and click Paste Visible and then tell it what range you want it to be pasted into and and click ok. No copy paste required.
This comment was minimized by the moderator on the site
Why the kutools is not working for the paste value to visible cells?
This comment was minimized by the moderator on the site
Hi there,

Sorry for the late reply. Are you still experiencing the problem? If yes, please follow the modified tutorial.

Amanda
This comment was minimized by the moderator on the site
This isn't working for me - am I missing a trick?
This comment was minimized by the moderator on the site
This particular function is not working for me either. And this was the one I really needed...
This comment was minimized by the moderator on the site
me either, the paste visible has no video to demonstrate now.
This comment was minimized by the moderator on the site
Hi there,

There is a demonstration video at the end of the page. Please follow it. If there is any problem, don't hesitate to ask me.

Amanda
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations