Show All

Sort rows in Datasheet view

You can sort data in a Datasheet view in two ways – when defining a view, and when a list is opened in Datasheet view. When you specify a sort order as part of the view definition, it is saved as part of the definition, and is applied each time you open the view. In addition, you can sort data after opening the view. These sort orders are not saved.

To sort on a single column

To sort on multiple columns

Notes

• You can also sort on multiple columns by using the drop-down arrow in the column headers. The first column you sort on becomes the innermost column, and the last column you sort on becomes the outermost column.
• You can apply one or more filters on a sorted view.
• The columns of type multiple lines of text and multi-choice do not support sorting. If a column does not support sorting, the sorting commands will be disabled for that column.
• The order of rows after sorting depends on the type of data in the columns that are used for sorting.

  Default sort orders for different types of data

  In an ascending sort, the Datasheet view uses the following order. In a descending sort, this sort order is reversed except for blank cells, which are always placed last.

  Type of data	Sort order
  Numbers	Sorted from the smallest negative number to the largest positive number
  Alphanumeric	Sorted left to right, character by character. For example, if a cell contains the text "A100," it is placed after a cell that contains the entry "A1" and before a cell that contains the entry "A11." Text and text that includes numbers are sorted in the following order: 0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` { | } ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last.
  Logical values	No is placed before Yes.
  Error values	All error values are treated as equals for sorting purposes.
  Blanks	Blanks are always placed last.