Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 528
  • Last Modified:

Excel - Copy/Paste Filtered Cells

Hi,

Please explain why when I filter data, and then copy/paste - all cells in between the visible filtered cells are also pasted.

How can I avoid this from happening?

Thank you.
0
tahirih
Asked:
tahirih
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

select the cells, then hit F5, click the Special button and tick "visible cells only". Then copy and paste.

cheers, teylyn
1
 
tahirihAuthor Commented:
Thank you
0
 
jppintoCommented:
Ctrl+G opens the Goto window. Click on the Special button and select the "visible cells only" option.
Capture.JPG
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now