Pivot Table -- Don't want first column sorted at all

  • Thread starter Thread starter Rob Miller
  • Start date Start date
R

Rob Miller

I have created a pivot table with totals for 20 years, one in each column.
The data in the source table appears in a certain order, WHICH I'D LIKE
PRESERVED in the pivot table.

The pivot table, however, wants to sort things alpha or something. That
is bad. I don't want that.

How do I have it NOT sort the categories down the first column?

Thanks.

Rob Miller
Oakland CA
 
You can set the field to sort manually, or create a custom list with
your items in the preferred order, and set the field to sort automatically.

To create a custom list;
1. Type your list in a column
2. Select the list
3. Choose Tools>Options
4. On the Custom Lists, click Import
5. Click OK
 
Back
Top