Sorting in a pivot table

C

C.S.

Board Regular
Joined
Nov 20, 2008
Messages
89
I've built a pivot table, and put a field in the 'Drop Page Fields Here' box. However, (using State abbr) the states are appearing in what looks like a random order. How can I sort this alphabetically?

Thanks,
Clint
 
Sort by date Sort by votes
this is from help

Stop sorting or return the items to their original order

On the PivotTable toolbar, click PivotTable, and then click Sort and Top 10.
Under AutoSort options, click Manual to stop automatic sorting or Data source order to return the items to their original order.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
How do I create a pivot table with a simple timesheet table?
Replies
0
Views
84
studioacosta
S
J
  • Question Question
Manual calculation of the median from a series of grades
2
Replies
14
Views
394
felixstraube
F
A
  • Question Question
referencing pivot table in another workbook
Replies
0
Views
95
ajm
A
drom
  • Question Question
pivot table SORT in data source order
Replies
1
Views
2K
Misca
M
B
  • Question Question
Create calculated field in pivot table that will sum all values greater than zero/exclude negative values
Replies
3
Views
150
RoryA
RoryA

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top