How to Copy Only Visible Cells in Excel

Date:2022-11-4 Author:Sandra

We may filter or hide columns/cells rows to classify or analyze data easily. But copy and paste can not work normally in this situation. For example, how to copy only visible cells in Excel? Let’s check this out.

Default copy and paste with hidden cells in Excel.  

Here is a score table for classes 1 to 3. If we hide rows from 6 to 15.

How to Copy Only Visible Cells in Excel

Now we copy the scores table by pressing Ctrl and C to paste them.

We can find that all the rows are copied, even if they are hidden. 

How to Copy Only Visible Cells in Excel

Here are three ways to copy only visible cells in Excel.

Method 1 Alt +[ ;]

Select the area first, and press Alt and ; , then you just copy and paste it by Ctrl + C and Ctrl +V. Alt +; can help us to select visible cells.

How to Copy Only Visible Cells in Excel

Method 2 F5

Select the area and press F5 to open Go To dialogue and click on Special.

How to Copy Only Visible Cells in Excel

Check the check box of Visible cells only and hit OK.

Now we can just copy and paste it into another sheet.

How to Copy Only Visible Cells in Excel

Method 3 Quick Access Toolbar

Go to File → Options → Quick Access Toolbar.

Add Select Visible Cells Commands and hit OK.

How to Copy Only Visible Cells in Excel
How to Copy Only Visible Cells in Excel

That’s all about the methods of how to copy only visible cells in Excel. See you guys next time~

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *