Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Excel 2010 - paste special in visible cells only

    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?
    thanks
    christine

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 341 Times in 334 Posts
    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

  4. #3
    Star Lounger
    Join Date
    Nov 2008
    Location
    Northeast US
    Posts
    59
    Thanks
    6
    Thanked 0 Times in 0 Posts
    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

Posting Permissions

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