'insert as printout' for multiple Excel sheets

B

BorisS

If an Excel file has multiple sheets, how does one 'insert as printout' for
all, or selected sheets, other than the first?
 
J

John Guin [msft]

Hello Boris,

Here's one method which may work. Open the excel workbook in Excel, then
print. Choose the Send to OneNote printer driver, and select to print the
entire workbook.

Each sheet of the workbook will now be inserted onto the page (but you won't
get the file embedded as an attachment).

As an aside, there is a powertoy at :
http://blogs.msdn.com/johnguin/archive/2007/09/19/an-addin-to-manage-printouts-to-onenote.aspx
which can help resize the printed pages on the page, break them out across
multiple pages and so on. You may want to take a look at it as well.
 
Top