You're welcome! Thanks for letting me know.

Matt Cromer wrote:
Awesome, the click, point border, and drag was exactly what I was looking
for!!!

Thanks
Matt

"Debra Dalgleish" wrote:


Select a cell in the row or column area
Point to its border, and drag it to a different position in the list

Or, you could create a custom list, and base the sort on that:

In a cell on a blank worksheet, type your list, then select it
Choose ToolsOptions
Select the Custom Lists tab
Click the Import button, click OK

When you create a new pivot table, items should be in the order of the
custom list.

To sort the items in an existing pivot table, select the field
button, and choose DataSort
Click the Options button, and choose your custom list.


Matt Cromer wrote:

Is there an easier way to use the Order function in Pivot Tables. Order,
Move Up/Move Down/Beginning...seems very awkward. The fields that I have
cannot be sorted ascending the traditional way, so I have to order them
manually. Are there any hot keys, or other ways to order??

Thanks!

Matt


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html