+ Reply to Thread
Results 1 to 4 of 4

Copy/paste visible cells only?

  1. 03-02-2014, 01:31 PM #1
    Royser12345
    Royser12345 is offline
    Registered User
    Join Date
    02-23-2014
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    49

    Copy/paste visible cells only?

    Hello,

    tried to google, but didn't find an answer. Please advice if it is possible to paste only visible cells without hidden/filtered cells? Also, whether it is possible to paste only to visible array and not to fill out hidden rows when copying?

    Thank you

    Regards
    Reply With QuoteRegister To Reply
  2. 03-02-2014, 01:35 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Copy/paste visible cells only?

    Copy visible cell, press F5 and click on Special, select Visible cells only.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 03-02-2014, 01:52 PM #3
    Royser12345
    Royser12345 is offline
    Registered User
    Join Date
    02-23-2014
    Location
    Norway
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Copy/paste visible cells only?

    Thank you very much!! It helped
    .,.. strange that in paste special I don't have this option
    Reply With QuoteRegister To Reply
  4. 03-02-2014, 01:52 PM #4
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Copy/paste visible cells only?

    You're welcome and thank you for your feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Copy and Paste Visible Cells Only to another Worksheet
    By excelnoob808 in forum Excel General
    Replies: 8
    Last Post: 05-30-2013, 03:28 PM
  2. Copy & Paste visible cells only
    By klopatios in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-06-2013, 03:59 AM
  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. [SOLVED] Copy and Paste Visible Cells
    By Lost and Looking for Help in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-08-2006, 10:20 AM
  5. [SOLVED] Copy & Paste visible cells only
    By Scott in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-23-2005, 12:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1