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 How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-1.png)
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 How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/GIF.gif)
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 How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/GIF2.gif)
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 How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-2.png)
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 How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/GIF3.gif)
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](https://www.myofficetricks.com/wp-content/uploads/2022/11/image-3.png)
![How to Copy Only Visible Cells in Excel How to Copy Only Visible Cells in Excel](https://www.myofficetricks.com/wp-content/uploads/2022/11/GIF4.gif)
That’s all about the methods of how to copy only visible cells in Excel. See you guys next time~
Leave a Reply