Printing column A with other columns

[Chemistification]

Sounds like quite a basic request but am not sure how to go about it. I have a spreadsheet that has a lot of columns. I want to print certain columns but want each page to have Column A showing on it.

So for example if i wanted to print columns X and BB and BZ i would want it to print A and x on one page, A and BB on another page and A and BZ on another page. Is there a way of doing this automatically?

Failing that how would i print column A with every column in one go. So is there a way of setting up a spreadsheet so that when i hit print i get column A and b printed, column A and C printed, column A and D printed and so on...

Thanks in advanced

[Cheeky Charlie]

We could do something with a macro, like:

hide all columns except A & B
loop
print
hide column <B>
unhide column <C>
do loop

where the <B> and <C> incremement one column each loop

How does that sound to you?

We could add functionality where you put an 'x' in row 1 of the columns you want to print, so you could explcitly set the combinations, which I think was the point of the first example?

If this sounds good, I will write a macro along these lines.

CC

[Chemistification]

Hi Charlie,

Yes that sounds exactly like what i am after. I like the part about adding an x in each column that needs to be printed.. nice.

[Cheeky Charlie]

Try this:

Please Login or Register  to view this content.

HTH