-->
Establishes automatic field-sorting rules for PivotTable reports.
- Jan 22, 2020 Excel Memory Stack. Excel uses a portion of the computer's RAM to maintain a list (often called a stack) of recent changes made to a worksheet. The undo/redo combination of commands allows you to move forward and backward through the stack to remove or re-apply those changes in the order they were first made.
- Luckily, Excel includes controls for quickly switching the order of axis values. To make this change, right-click and open up axis options in the Format Task pane. There, near the bottom, you'll see a checkbox called 'values in reverse order'. When I check the box, Excel reverses the plot order. Notice it also moves the horizontal axis to the.
- There is no built-in function or tool available in excel to reverse the order. A combination of INDEX + ROWS will reverse the order. Of all the available techniques, the sort option is the better and easy way to sort. To understand VBA code, you need to have prior knowledge of VBA macros.
In Excel for Mac, you can sort a list of data by days of the week or months of the year. Or, create your own custom list for items that don't sort well alphabetically. You can also sort by font color, cell color, or icon sets. If you have Kutools for Excel installed, you can reverse the numbers order of columns with Flip Vertical Range tool quickly. Before applying Kutools for Excel, please.
Syntax
expression.AutoSort (Order, Field, PivotLine, CustomSubtotal)
expression A variable that represents a PivotField object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Order | Required | Long | One of the XlSortOrder constants specifying the sort order. |
| Field | Required | String | The name of the sort key field. You must specify the unique name (as returned from the SourceName property), and not the displayed name. |
| PivotLine | Optional | Variant | A line on a column or row in a PivotTable report. |
| CustomSubtotal | Optional | Variant | The custom subtotal field. |
Example
This example sorts the Company field in descending order, based on the sum of sales.
Support and feedback
Excel Reverse Rows
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.