The Sort page allows you to customize settings related to sort function.
If this is checked, fast binary comparison is used to sort. The locale information is ignored when this is checked.
If this is checked, stable sort is used. The stable sort maintains the relative order of records. The stable sort is usually slower.
If this is checked, case is ignored.
If this is checked, corresponding Hiragana and Katakana characters compare as equal.
If this is checked, nonspacing combining characters, such as diacritics, dakuten, and handakuten, are ignored.
If this is checked, symbols are ignored.
If this is checked, the difference between half-width and full-width characters is ignored. The full-width form is a formatting distinction used in Chinese and Japanese scripts.
Hyphen and apostrophe are treated as normal characters. This is off by default to ensure that words containing hyphen or apostrophe are matched when sorting by letter.
If this is checked, digits are sorted as numbers even when using Sort A to Z or Sort Z to A commands. For example, "2" is sorted before "10".
If this is checked, leading non-numeric characters are ignored when using Sort Smallest to Largest or Sort Largest to Smallest commands.
If this is checked, full width characters are treated as 2 characters when using Sort Shortest to Longest or Sort Longest to Shortest commands.
Compares unquoted strings in cells of CSV documents. For instance, when a cell strings is "a""b", the actual string to compare will be a"b.
Inspects only selected strings for sort when vertical selection or multiple selections exist.
Group identical strings when sort by occurrence.
Specifies the locale used for the sort.
Resets to default settings.