Keeping hidden columns HIDDEN in a copy-and-paste

[leojbramble]

Is there any way to keep columns hidden when they are copied from one
spreadsheet and pasted into another?

I have a master spreadsheet from which groups of rows are being copied
into a number of individual spreadsheets. There are certain columns
that are hidden in the master, and I want to KEEP those columns in the
individual spreadsheet spreadsheets, but leave them hidden when I do
the paste. Is there a way to avoid having to re-hide the appropriate
columns every time I paste?

Similarly, is there a way to maintain the column widths of the original
when pasting? Thanks much.

 

[Earl Kiosterud]

Leo,

If you copy the entire row, the hidden property will be set when you paste.