Forum Discussion
Copy and paste visible cells only in Excel 2016
Hello, dears! I have trouble with copying visible cells only and pasting in the same visible cells of another sheet in excel 2016. I could copy the visible cells by using Alt +; keys, but I could n...
Try using the below steps to copy visible cells:
1. Highlight the range that is visible
2. Home > Find & Select > Click the Visible Cells Option > Click OK
3. Ctrl + C
However, when you paste you cannot paste to only visible cells. You can see that this is not possible:
https://support.office.com/en-us/article/copy-visible-cells-only-6e3a1f01-2884-4332-b262-8b814412847e
This article references this limitation:
"Note: Excel pastes the copied data into consecutive rows or columns. If the paste area contains hidden rows or columns, you might have to unhide the paste area to see all of the copied cells."