+ Reply to Thread
Results 1 to 5 of 5

Excel 2013: Paste Data into Visible cells only

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    1

    Question Excel 2013: Paste Data into Visible cells only

    when you attempt to paste values into a filtered table. Excel pastes in a contiguous block, ie does not skip the lines that are filtered out, so you end up pasting your data into wrong rows.

    Example:
    In worksheet I have created two Filter Column one for Product and another for Value, I have filter out Product on there name basis (Product=a).
    wanted to copy values from another cells and paste on to those cells where "Product=a". while doing so it will paste data into hidden cells also. which was not expected. looking to paste data onto visible cells only.

    So is there anyway we can paste data into visible cells only???

    Thanks in Advance....
    Last edited by nikams_85; 07-15-2013 at 02:33 AM.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Excel 2013: Paste Data into Visible cells only

    Im intrigued to see the answer to this, I have always dumped the data seperately and vlookuped in

  3. #3
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel 2013: Paste Data into Visible cells only

    you've gotta use code for that-there is no native way
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  4. #4
    Registered User
    Join Date
    07-10-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Excel 2013: Paste Data into Visible cells only

    try this

    Please Login or Register  to view this content.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Excel 2013: Paste Data into Visible cells only

    the question is about pasting to visible cells not copying from them

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Paste to visible cells only (Excel 2010)
    By dihris in forum Excel General
    Replies: 8
    Last Post: 11-15-2013, 03:48 AM
  2. Link Excel 2013 to Word 2013
    By drosen99 in forum Word Formatting & General
    Replies: 20
    Last Post: 02-26-2013, 08:20 PM
  3. Copy Visible cells and paste values only to visible target cells
    By wotadude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2010, 04:09 AM
  4. Paste Data into Contiguous (Visible) Cells
    By trev_sk8r in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-16-2006, 05:10 PM
  5. [SOLVED] Paste into Visible Cells Only
    By CR in forum Excel General
    Replies: 1
    Last Post: 06-10-2005, 03:05 PM

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