View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
badger_rich badger_rich is offline
external usenet poster
 
Posts: 6
Default Reorder pivot table field lists

Make sure that AutoSort Options are set to Manual for the field you are
trying to sort manually.

Right Click (or double-clcik) on the field name, choose "Field Settings...",
click on "Advanced" and select 'Manual ("you can ...")' under AutoSort
Options

--
Rich


"Josh Johansen" wrote:

I have a long list under certain pivot table fields, and I would like to
reorder them so they are not in alphabetic order. I have read in help that
you can drag and drop manually, but for some reason I cannot figure out how
to do it. Any ideas what I am doing wrong? Thanks.