Excel - Copy/Paste Filtered Cells

Posted on 2011-04-20
Last Modified: 2012-05-11

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.
Question by:tahirih
    LVL 50

    Accepted Solution


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

    cheers, teylyn

    Author Closing Comment

    Thank you
    LVL 33

    Expert Comment

    Ctrl+G opens the Goto window. Click on the Special button and select the "visible cells only" option.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now