Recently I was using OneNote to compile a lot of test data from Excel and ran into a problem. My data was in a number of different worksheets and when I dragged and dropped the Excel file as a printout into OneNote, I only got 1 of the sheets, not all of the many sheets of data.
I didn't want to keep inserting the sheets 1 by 1 so I looked into it and I figured out how to get the whole workbook into OneNote in 1 fell swoop...
[Read this blog...]