• Excel 2010 – paste special in visible cells only

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Excel 2010 – paste special in visible cells only

    Author
    Topic
    WScchambers@work
    AskWoody Lounger
    July 15, 2011 at 10:01 am #477822

    i’ve found in my new copy of excel 2010, when i copy and paste special values on a filtered list, it now pastes into hidden rows also where in 03, it pasted only on the visible cells. do you know how to revert to the process where i can restrict my pasting to visible cells only?

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSsdckapr
      AskWoody Lounger
      July 15, 2011 at 5:27 pm #1288534

      I never worked with XL2003, but XL97 and XL2000 as far as I remember would paste in a contiguous fashion, so would paste over hidden rows (wheter explicitly hidden or via autofilter). I find it hard to believe they implemented a feature to not paste contiguously in XL2003 that was then abandoned in XL2010, but stranger things have happened.

      Did you have to do a special process for this or was it just built-in? If a process, what is it, [perhaps it is still there in XL2010 and you just don’t know the steps]

      Steve

      Reply | Quote
      • WSMyers515
        AskWoody Lounger
        July 22, 2011 at 2:32 pm #1289424

        I keep the ‘Visible Cells Only’ icon on my shortcut bar and use that. If you Copy, hit the Visible Cells Only icon, then Paste Special, Excel will copy only into the visible cells.

        Meleia

        Reply | Quote
    Viewing 0 reply threads
    Reply To: Excel 2010 – paste special in visible cells only

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.