Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 07, 2016, 08:16:51 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Copying Collapsed Rows/Columns in Excel Misses Data  (Read 1391 times)

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,220
  • Tell me something you don't know...
    • View Profile
    • Renegade Minds
    • Donate to Member
Copying Collapsed Rows/Columns in Excel Misses Data
« on: January 16, 2011, 09:22:05 PM »
Sigh... I don't know why I always have to find so many stupid annoyances... Anyways, I'm posting this here in the hopes that it helps someone else avoid wasting time and a little pain:

Copying Collapsed Rows/Columns in Excel Excludes Hidden Data

The title basically says it all.

So, if you copy 51 rows, but only get 50 pasted, you now know why. :D
Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker

Perry Mowbray

  • N.A.N.Y. Organizer
  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 1,817
    • View Profile
    • Donate to Member
Re: Copying Collapsed Rows/Columns in Excel Misses Data
« Reply #1 on: January 16, 2011, 09:39:09 PM »
You sure they don't just get pasted in a collapsed state??

Target

  • Honorary Member
  • Joined in 2006
  • **
  • Posts: 1,606
    • View Profile
    • Donate to Member
Re: Copying Collapsed Rows/Columns in Excel Misses Data
« Reply #2 on: January 16, 2011, 09:56:58 PM »
You sure they don't just get pasted in a collapsed state??

nope, you get the collpsed data only

note that it can get really confusing when you go the other way, ie copy data TO a sheet with hidden rows or columns