Share via


Sort Data in a Table

You can sort data by text (A to Z or Z to A) and numbers (smallest to largest or largest to smallest) in one or more columns.

Note

In Windows Vista and Windows 7, features in the PowerPivot window are available on a ribbon, which is discussed in this topic. In Windows XP, features are available from a set of menus. If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see The PowerPivot UI in Windows XP.

To sort the data in a table based on a text column

  1. In the PowerPivot window, select a column of alphanumeric data, a range of cells in a column, or make sure that the active cell is in a table column that contains alphanumeric data.

  2. On the Home tab, in the Sort and Filter group, do one of the following:

    • To sort in ascending alphanumeric order, click Sort A to Z.

    • To sort in descending alphanumeric order, click Sort Z to A.

    Note

    In some cases, data imported from another application might have leading spaces inserted before data. You must remove the leading spaces in order to correctly sort the data.

To sort the data in a table based on a numeric column

  1. In the PowerPivot window, select a column of numeric data, a range of cells in a column, or make sure that the active cell is in a table column that contains numeric data.

  2. On the Home tab, in the Sort and Filter group, do one of the following:

    • To sort from low numbers to high numbers, click Sort Smallest to Largest.

    • To sort from high numbers to low numbers, click Sort Largest to Smallest.

    Note

    If the results are not what you expected, the column might contain numbers stored as text and not as numbers. For example, negative numbers imported from some accounting systems, or a number entered with a leading ' (apostrophe), are stored as text.

See Also

Other Resources