Print areas

[kevin]

hi

is it possible to set up a number of print areas of a
single spreadsheet. I have a very wide spreadheet lets
say 50 columns

I would always like to print column 1 but then say the
first 10 columns then 30 columns and then 10 columns

Is this possible or is it only via code

Thanks in advance

 

[Frank Kabel]

Hi
see:
http://www.rondebruin.nl/print.htm#non-contiguous

 

[Bernard Liengme]

The code would be very easy to do. Experiment with Tools|Macros|record macro
Record one that prints the three areas of interest.
Then come back and we can show you how to put a button on the worksheet to
run the macro.

 

[Jim May]

There is also "Custom Views" under Menu, View;
Check out in Help.