Export (0) Print
Expand All

Sort Data in a Table

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

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 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 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 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.

Community Additions

ADD
Show:
© 2014 Microsoft