OneNote Gem Add-Ins

OneNote sort table by multiple columns

Gem for OneNote 23 add a new feature to sort OneNote native table by two or multiple columns.

Sort table according to the columns order
  1. At firs, select a table or put the cursor in the table.
  2. New ribbon "Table Tools" appear in last main ribbon, a new "Gem" tab be shown on last of ribbon, click the "Sort" menu -> "Custom Sort …" menu item.

Columns: Choose Columns Order Type
In the pop up "Sort Selected Table" dialog, choose the order type for columns
There are 5 sort order type for columns:
  • Not sort
  • A - Z
  • Z - A
  • 0 - 9
  • 9 - 0

In this example, 
  1. First sort column 6 by 0 - 9,
  2. Next sort column 8 by 9 - 0.

Rows: Specify the Exclude Rows
  1. Specify how many rows be excluded in table header.
  2. Specify how many rows be excluded in table footer.

In this example,
1 row in header and 1 row in footer in table will be excluded in sorting.
Click the "Sort" button, we will got the following result.
 
Picture
 
Picture
 
Sort Table by specify the columns sequently

We can move up the column 8 to top of the column 6.
 
Picture
 
Click the "Sort" button, Gem will perform follow steps.
  1. First sort column 8 by 9 - 0.
  2. Next sort column 6 by 0 - 9.
Picture
 
Download Gem for OneNote