How do I stop copying hidden columns?

[Guest]

Columns for each record in my main spreadsheet are wanted for different
purposes. I thought I could simply hide the columns that weren't needed and
copy the values for the ones I wanted to do more work on, into a separate
sheet. But I find that the 'hidden' columns are being copied too!

How can I copy and paste just the columns I need? I would have thought this
was a basic necessity of a spreadsheet - and, indeed, the point behind
hiding columns -, so I hope I don't have to copy the whole thing and delete
columns each time! (I suppose I could link each column in the second sheet,
but I would have thought cutting and pasting would have been sufficient, and
less complicated.)

Cheers,

S

 

[Guest]

Columns for each record in my main spreadsheet are wanted for different
purposes. I thought I could simply hide the columns that weren't needed
and copy the values for the ones I wanted to do more work on, into a
separate sheet. But I find that the 'hidden' columns are being copied
too!

How can I copy and paste just the columns I need? I would have thought
this was a basic necessity of a spreadsheet - and, indeed, the point
behind hiding columns -, so I hope I don't have to copy the whole thing
and delete columns each time! (I suppose I could link each column in the
second sheet, but I would have thought cutting and pasting would have been
sufficient, and less complicated.)

Cheers,

S

OK I've discovered the well hidden 'select visible' button and now can paste
as I wanted.

Which makes me now want to try the other option, which I will start as a new
thread.

S

 

[Guest]

Most of the time, I would WANT to copy the hidden columns. I would have
some spreadsheets with intermediate values that I would not want to
clutter the screen. In the old days, a simple macro would be able to
modify those columns.

Bill

Thanks Bill,

Most of the time I would want to copy the hiddens too, but this is in the
middle of a catch up and redesign exercise transposing stuff from muddled,
often misnumbered, inconsistently dated and filenamed and poorly thought out
receipts and invoices - none of my doing I would hasten to add. To pull it
all together I'm having to spread out a lot until I've discovered all the
parameters, and decided on the best layout and how to divide it up into
various sheets for different purposes. Then it has to be as idiot proof as
possible, as the end user finds hiding/split screening and even freezing
panes rather confusing, so I want to keep them all to a minimum.

I've discovered that there is an extra tool bar button that does what I
wanted to do, for the time being, but in the future I would like the
subsidiary sheets to fill themselves in from the main sheet as I (or
hopefully the person who has dumped this mess on me to sort out!) goes
along: hence my new question on how to write formulas/references for whole
columns at a time. I'm sure I used to be able to do it, but it is some time
since I really got down to using this excellent programme in earnest, and
I've forgotten rather a lot! ;-) (Incidentally, in the old days - Say
W3.11 - even the thought of writing a macro was enough to crash my computer:
never have trusted them since, so they remain something of an unknown
quantity to me!)

Cheers,

S