Monday, January 22, 2018

Sort table data in OneNote

Sort table data in OneNote

If you insert a table in your OneNote 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 installed on the same computer as OneNote, 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.

No comments:

Post a Comment