Locked lesson.
About this lesson
This lesson will show how to convert a table in OneNote into an Excel worksheet.
Exercise files
Download this lesson’s exercise file.
5.08 Convert OneNote Tables to Excel - Exercise.docx62.1 KB
Quick reference
Convert OneNote Tables to Excel
This lesson will show how to convert a table in OneNote into an Excel worksheet.
When to use
This will save you time, so you don't have to retype info in Excel that is already in OneNote.
Instructions
- Go into OneNote
- Go into any notebook
- Click anywhere on the page
- Click on the Insert menu, then click Table
- Highlight the number of rows and columns you want from the picture of the table and click to insert the table
- You should see the table in OneNote
- Click on one of the cells of the table
- You should now see the Table menu in OneNote
- Click on the Convert to Excel Spreadsheet icon on the right side of the Table Menu
- The table has now been converted to an Excel spreadsheet
- If you click on Edit within the table window, it will open that spreadsheet in Excel
Login to download
Lesson notes are only available for subscribers.