Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Alphabetize Pivot Table
Hello, How can you alphabetize the page field in a Pivot table? I have my
data alphabetized but one item in the dropdown in the page field is out of order. |
#2
|
|||
|
|||
I've tried the Field Settings AutoSort in Ascending order but I still have
one out of place. "xgirl" wrote: Hello, How can you alphabetize the page field in a Pivot table? I have my data alphabetized but one item in the dropdown in the page field is out of order. |
#3
|
|||
|
|||
One of the items might be an entry in one of the custom lists
(ToolsOptions, Custom Lists) Try moving the field to the row area, change it to manual sort, and use the A-Z button on the toolbar to sort it. Then, move it back to the page area. xgirl wrote: I've tried the Field Settings AutoSort in Ascending order but I still have one out of place. "xgirl" wrote: Hello, How can you alphabetize the page field in a Pivot table? I have my data alphabetized but one item in the dropdown in the page field is out of order. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table to include additional rows | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |