I hide different columns on my spreadsheet to make different smaller
sheets that I can print out and that demonstrate particular aspects of
the overall thing.

This is no problem when printing.

But when I want to send by email I find I cannot copy these smaller
sheets - every attempt at a copy will also copy the hidden columns.

How to copy a spreadsheet and NOT pick up the hidden columns?

I realise this might be nearly impossible or considered useless because
no hidden columns would mean either making the copy with blank hidden
columns or altering all formulas to suit a sheet which now does not
have all the original columns.

But I'd be prepared to work on such a sheet myself - e.g. the copied
sheet might have only one column of fomulas - all of which are now
useless if hidden columns have been deleted - but it would be easy for
me to rewrite that one column - copy one new formula down.

As it is I get the whole sheet - all the hidden columns. Then I have
to delete them and rewrite. Only a few more mouseclicks, I admit - but
I'm wondering if there is an easier, knowing just how clever excel can
be sometimes.

And now I suddenly realise I don't know if the emailed recipient would
get a sheet with the hidden columns still hidden? If he would I could
tell him to be careful and retain the hidden columns as hidden - in
fact to print out immediately and see what I'm trying to show him.

Any ideas on all this?

regards,

ab :)


--
abrogard
------------------------------------------------------------------------
abrogard's Profile: http://www.excelforum.com/member.php...o&userid=24236
View this thread: http://www.excelforum.com/showthread...hreadid=387432