Share via

Tables inside OneNote

Anonymous
2015-07-19T10:04:25+00:00

Can One Note tables contain fields that use Exel-type formulas? If yes, how?

Microsoft 365 and Office | OneNote | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-07-20T05:09:44+00:00

Hi Peter,

Welcome to Microsoft Community. I understand that you want to know about using formulas in OneNote table.

You can create and edit tables directly in OneNote but it is not possible to use aggregate functions (e.g., sum, average) on OneNote table columns.

If you want to capture, share, and analyze a list of structured information, inserting Excel workbooks into OneNote pages is a useful option.

Please refer article: Add an Excel spreadsheet to a page in OneNote 2016 for Windows

https://support.office.com/en-us/article/Add-an-Excel-spreadsheet-to-a-page-in-OneNote-2016-for-Windows-a8ccd3fc-d61e-4913-b2a0-195d66599d92

Hope this helps. Please reply if you need further assistance.

Thank you.

Was this answer helpful?

3 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest