Search
OneNoteGem
  • Home
  • Addins
    • Windows Office Addins >
      • Gem for OneNote
      • OneNote Search Bar
      • OneNote Gem - Favorites
      • OneNote Batch
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • Row to OneNote
      • Auto OneNote
      • Favorite to OneNote
      • Bridge for EndNote and OneNote
      • Anchor to OneNote
      • Anchor to OneNote for PDF
      • Bring to OneNote
      • Gem Table for OneNote
    • Windows UWP Addins >
      • Gem Menu for OneNote UWP
      • CiteBoard for OneNote
      • OneReader
      • OneMind for Windows OneNote
      • OneNote Reminder Cloud (UWP)
      • OneNote Batch Cloud (UWP)
    • Mac Addins >
      • Gem Menu for Mac OneNote
      • CiteBoard for OneNote
      • Bring to Mac OneNote
      • OneMind for Mac OneNote
      • OneNote Reminder for Mac
      • OneNote Batch for Mac
      • Fix One for Mac - Fix OneNote Login, Sync Tools
    • Android Addins >
      • CiteBoard for OneNote
      • Fix One for Android - Fix OneNote Login, Sync Tools
    • Cross-Platform Addins >
      • OneNote Reminder
      • OneMind for OneNote
      • CiteBoard for OneNote
      • Fix One - Fix OneNote Login, Sync Tools
    • Markdown Addins >
      • Gem for OneNote
      • One Markdown
    • Mind Map Addins >
      • OneNote Gem - Favorites
      • Pons for MindManager and OneNote
      • Mind Map for OneNote
      • Pons for Visio and OneNote
      • OneMind for OneNote
    • Other Addins >
      • One Markdown
      • Clip to OneNote
      • WordNote
      • OneShare
      • Fix One for Windows - Fix OneNote Login, Sync Tools
  • Buy
  • Documents
  • FAQs
  • Templates
  • Support
  • Release
  • WordNote
Gem Table for OneNote
 
 
The table of merged cells for OneNote

OneNote sort table by multiple columns

2019-11-24 00:18
 
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

Related Documents

  • Formula for OneNote Table Document
  • Copy OneNote Selected Cells, Paste and Replace the Selected Cells in another Table
  • Currency Style for OneNote Cells
  • How to apply Comma Style for OneNote table cells
  • Convert Text to Table in OneNote
Command Line
Tag System
MindMap Add-Ins Comparison
Search Add-Ins Comparison
One Markdown Syntax
Table Formula
Gantt

Gem Menu Templates
Repair OneNote
OneNote Download
English website Chinese website
Mobile Site
Copyright © 2011-2025 Digital GemSoft. OneNoteGem.com All Rights Reserved.