+ Reply to Thread
Results 1 to 6 of 6

Avoiding Copy & Paste in Hidden/Filtered Cells

  1. #1
    Forum Contributor garrett.grillo's Avatar
    Join Date
    06-19-2011
    Location
    San Francisco, California
    MS-Off Ver
    Excel 2010
    Posts
    188

    Avoiding Copy & Paste in Hidden/Filtered Cells

    I have a spreadsheet that I have hidden / filtered out data from a previous Vlookup. The only data I wish to apply is the additional to the unhidden / unfiltered rows that are currently blank or show a #N/A. But when I copy and paste the equation down all the unhidden / unfiltered rows the hidden / filtered rows are changed picking up the new additional data. How do I work around this?

    Thank You.
    Last edited by garrett.grillo; 02-13-2012 at 03:23 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: Avoiding Copy & Paste in Hidden/Filtered Cells

    Select the data range you want to copy then press F5, click <Special>, <Visible cells only>, <OK>. Right click on the selection and copy. When you paste it will only paste the visible cells.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

  3. #3
    Registered User
    Join Date
    09-05-2013
    Location
    Pune
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Avoiding Copy & Paste in Hidden/Filtered Cells

    This is not working 'tuph'.

    today I spent but I could not copy paste in to visible cells. someone can please help on this?

    Quote Originally Posted by tuph View Post
    Select the data range you want to copy then press F5, click <Special>, <Visible cells only>, <OK>. Right click on the selection and copy. When you paste it will only paste the visible cells.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Avoiding Copy & Paste in Hidden/Filtered Cells

    nandkishorskale, this post is just over 2 years old. Please acquaint yourself with forum rules (#2 I believe) and start your own post for your problem. That way you can get specialized help for your issue.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    09-05-2013
    Location
    Pune
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Avoiding Copy & Paste in Hidden/Filtered Cells

    Quote Originally Posted by Sambo kid View Post
    nandkishorskale, this post is just over 2 years old. Please acquaint yourself with forum rules (#2 I believe) and start your own post for your problem. That way you can get specialized help for your issue.
    How to start my own post in Excel forum?
    please give steps.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: Avoiding Copy & Paste in Hidden/Filtered Cells

    Pick the forum you want it in (e.g. General) then at the top is a blue button with a plus sign for posting a new thread. just click on and follow the steps.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1