You can use the ‘Go to Special’ method for paste in visible cells only this action won’t work on multiple selections. Simply select and copy the cells. Then, go to ‘Home’ tab >> locate & click on ‘Find & Select.’ After this, reveal the dropdown menu & then select ‘Go to Special.’ >> ‘Visible cells only’ >> then click on ‘OK.’ Now, press CTRL + V keys to paste the value.