Copying Collapsed Rows/Columns in Excel Misses Data

[Renegade]

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.

[Perry Mowbray]

You sure they don't just get pasted in a collapsed state??

[Target]

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