Easy deploying in your enterprise or organization.
Click F5 key or the Run button, then a dialog is popping out for you to select values to copy. Set OutRng = Application.InputBox("Paste Range:", xTitleId, Type: = 8) Set InputRng = Application.InputBox("Copy Range :", xTitleId, InputRng.Address, Type: = 8) Click Insert > Module, then paste below VBA code to the popping Module window. Press Alt + F11 keys simultaneously, and a Microsoft Visual Basic for Applications window pops.Ģ. Change the option to ALL COMMANDS and then scroll down until you find the ‘Select Visible Cells’ button. First right click in your Quick Access Toolbar (look for the undo/ redo buttons) and click on Customise Quick Access Toolbar as shown below.
In Excel, there is no other ways to solve this problem except VBA.ġ. Option 2: Select Visible Cells Shortcut button. Paste values to visible cells with Paste to Visible Range of Kutools for Excel Here I will tell you some tricks to paste values to visible cells only in Excel. In Excel, if you have filtered data or hidden some cells, and when you paste values into the filtered or hidden range, the hidden cells will be also filled with pasted values.
How to paste values to visible/filtered cells only in Excel?