Export (0) Print
Expand All

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.

NoteNote

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.

    NoteNote

    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.

    NoteNote

    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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft