LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Pivot table sort order

If I go into PivotTable Field Settings, then Advanced, there's an
option under AustSort Options for "Manual (you can drag items to
rearrange them)". How does this work? I can't see where I can drag &
drop items, it doesn't work on the spreadsheet & I can't see where
elese to do it? The only sort order I can seem to work is ascending
or descending.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort order not being matched in pivot table Deanery Phil Excel Discussion (Misc queries) 2 January 8th 07 08:34 AM
Pivot Table out of order reno Excel Discussion (Misc queries) 2 August 24th 06 08:42 PM
Getting Pivot Tables to automatically sort rows in alphabetical order Kei Excel Discussion (Misc queries) 1 March 9th 06 05:24 PM
Pivot table sort order Vincdc Excel Discussion (Misc queries) 2 March 1st 06 05:20 PM
I have two identical pivot tables with different sort order of th. WilliamJFoster Excel Discussion (Misc queries) 1 April 7th 05 03:48 AM


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"