Sort table data in OneNote 2016 for Windows

If you insert a table in your OneNote 2016 notes, you can sort the table info alphabetically or numerically.

  1. Click any cell in your table.

  2. Click Layout > Sort, and then click either Sort Ascending or Sort Descending.

    Notes: 

    • To sort two or more rows in your table, and not the whole table at the same time, select the rows you want to sort, and click Layout > Sort > Sort Selected Rows.

    • To set a particular row in your tables as the starting point for sorting, select the row, and click Layout > Sort > Header Row.

If you have Excel 2016 installed on the same computer as OneNote 2016, you can convert any table in your notes into an Excel spreadsheet. Click the table, and then click Layout > Convert to Excel Spreadsheet. When you double-click the Edit button in the embedded spreadsheet that appears, it will open in Excel.

Top of Page

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×