×
英语
很抱歉。本文没有你的语言版本。

Convert a OneNote table to an Excel worksheet

Sometimes, to improve the look of a table on a page, you might format a table to resemble a simple spreadsheet. In OneNote 2013 or 2016, you also have the option to convert it to a fully functioning Microsoft Excel spreadsheet.

  1. In OneNote, open the page that contains the table you want to convert.

  2. Activate the table by clicking inside any of its cells and reveal the hidden Table Tools tab.

  3. In the Table Tools tab, choose Convert to Excel Spreadsheet.

    Screenshot of the Convert to Excel Spreadsheet button in OneNote 2016.

OneNote converts the table to an Excel spreadsheet and inserts a icon on the page and an embedded dynamic preview of the file. When you change or update the spreadsheet, the preview on the notes page automatically updates.

If your data is already in a spreadsheet, you can add an Excel spreadsheet to your page.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×