Excel printing problems

[bitter]

I have been using excel for some time without any real problems.
Recently I have found it necessary to print multiple worksheets onto one A4 sheet for archiving purposes. After trying the normal route of selecting "mutliple sheets per page" in the printer properties options, I just get the first sheet of the workbook printed in the top left-hand corner of the sheet and that`s it!
The same approach works fine with Word - so I`ve had to resort to using "Open Office" to print out for my archiving purposes.

Anyone got any ideas about what I may be doing wrong?

 

[erik.van.geit]

Hi, bitter
Welcome to the Board !!!!!

Do you mean you want to print multiple workSHEETS on one sheet of paper ?
Therefore you would need to create a summarysheet (manually or using code)

The option you tried, works for multiple PAGES on a SINGLE workSHEET.

kind regards,
Erik