Forum Discussion

Hamid Hadi's avatar
Hamid Hadi
Copper Contributor
Apr 30, 2018

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 not paste it in the same visible cells of another sheet.

Can anyone help me? Please

All the best

Hadi

Copy and paste visible cells only in Excel 2016
  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 01, 2018

    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:

     

    Microsoft Support Article

     

    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."

     

     

Resources