How do I paste in Microsoft excel and keep hidden rows hidden? I know there's an option only to paste all visiable rows/columns - but this doesn't keep the information in the hidden rows available when you paste. I know there's an option to paste format...but this only helps with hidden columns. Please help??
Microsoft Excel - paste without showing hidden rows (keep hidden)?symantic
The only options I can think of end up eliminating the hidden data. It is weird that Excel only give you an option to copy column widths and not row heights, at least in my version (2000.)
If you have time to prepare in advance of the copy/paste, you can set up a blank sheet with all the proper hidden rows and when you paste in, the rows stay hidden. This doesn't help you if your hidden rows change from event to event. It is just changing when you go and hide your rows from after your paste to before your paste.
Can you arrange the data in columns instead of rows, do the paste operation and later select only visible, then copy and paste transpose. This still removes the hidden data, but you can keep the hidden properties in your column arranged section.
Good Luck!
A note: I MS Access this can easily be accomplished with Filters, if your hidden data can be segregated by values in the data. Are you trying to put in a screw with a hammer?
No comments:
Post a Comment