Main Area and Open Discussion > General Software Discussion

Copying Collapsed Rows/Columns in Excel Misses Data

(1/1)

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. :D

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??-Perry Mowbray (January 16, 2011, 09:39 PM)
--- End quote ---

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

Navigation

[0] Message Index