Printing several worksheets as on page

[Guest]

I have read the detail of "Printing weveral worksheets as_one_print job", but
trying everything, the results is that 3 worksheets still print as 3 pages on
the printer.

My need is as follows: I have 3 spreadsheets with little data on it. If
one cut and paste, merge cells across columns to take care of different
column widths etc. all the data can be printed as one sheet. It is just much
simpler to keep the data as 3 separate sheets, but once printing, to be able
to easily print it a 1 sheet for example.

The solution for "Printing weveral worksheets as_one_print job" did not
solve this problem for me. Is it possible to do?

 

[NickHK]

Not sure which article you are referring to, but...
One way is create a linked picture of the range on the other 2 sheets on the
3rd. Then just print the 3rd.

- Copy the range
- Shift+Edit>Paste Picture Link

NickHK

 

[Guest]

Thanx, I will investigate if the solution suffice.
--
Coenie Brand
PTA, SA

Not sure which article you are referring to, but...
One way is create a linked picture of the range on the other 2 sheets on the
3rd. Then just print the 3rd.

- Copy the range
- Shift+Edit>Paste Picture Link

NickHK