OneNote Gem Add-Ins

Select What to Display for Excel Spreadsheet in OneNote

In OneNote 2013,  we can insert an existing Excel Spreadsheet.

Click "Insert" tab -> "Files" group -> "Speadsheet" menu -> "Existing Excel Spreadsheet" item to insert an existing Excel Spreadsheet.
Picture
 
We can choose 3 styles to insert Excel spreadsheet.
Picture
 
Picture
1. Insert as Attach File
Picture
2. Insert as Spreadsheet
Picture
3. Insert a Chart or Table ( Custom Insert ) You can choose display which work sheet.
Select What to Display …

If you have insert Excel Spreadsheet as Attach File, you also can choose to display table or chart only.

Right click on an Excel Attach file, and click "Select What to Display …" on the context menu.
Picture
 
It will pop up "Custom Insert" dialog again. You can choose which work sheet to display in OneNote page.
Picture
 
EXE Addins UWP Addins MAC Addins