Did you know that you can add Excel worksheets to your page in OneNote? OneNote as a Microsoft product offers the feature to import an Excel spreadsheet into OneNote so that you can save a worksheet from an Excel file into your OneNote notebook rather than copy and paste the file. In OneNote, you can add an existing Excel worksheet or add a new Excel spreadsheet.
Embed Excel spreadsheet in OneNote
In this tutorial, we will discuss how to add an existing Excel spreadsheet and how to add a new Excel spreadsheet.
How to add existing Excel spreadsheet in OneNote
On the Insert tab in the File group, click the Spreadsheet button.
In the drop-down list, click Existing Excel Spreadsheet.
A Choose Document to Insert dialog box will appear
In the dialog box, select an Excel file and click Insert.
An Insert File dialog box will appear.
Inside the box, if you select Attach File, a link to the file will appear on the OneNote page.
If Insert Spreadsheet is selected, the file will be displayed on the OneNote page.
Insert a Chart or Table is used to insert spreadsheet charts and tables.
In this tutorial, we chose Insert Spreadsheet.
The spreadsheet you selected will appear on the OneNote page.
How to insert new Excel spreadsheet in OneNote
Click the Spreadsheet button.
In the drop-down list, click New Excel Spreadsheet.
A blank spreadsheet will appear on the OneNote page.
You can type into a mini box on the spreadsheet or place the cursor on the top left corner of the spreadsheet, then click the Edit button.
The Excel program will open.
Where you can edit the spreadsheet.
After you edit the spreadsheet, please save the file, then close; the data will appear in the spreadsheet on the OneNote page.
We hope this tutorial helps you understand how to insert Excel spreadsheets in OneNote.