View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lisa F Lisa F is offline
external usenet poster
 
Posts: 10
Default Pivot Table sort -Excel 2007

I have an Excel spreadsheet with data in column 1 that is in an order which
only makes sense to me. I need to leave it in this order when I create the
Pivot Table. When I create the Pivot Table I drag this field to ROW LABELS.
At this point it will sort A-Z or Z-A. I want it to stay just like it shows
on my spreadsheet. I have checked the forum and have yet to find an answer.
--
Lisa Fornal