thanks to every one in advance...
i have a pivot table and if i select my headers i have the availability to sort a-z and z-a plus manual ...manual says to drag the item where i would like it...i have tried various ways to do this but am stumped. i have tried the excel help database..they reference manual sort but really give no explanation.
scenario..
i want to sort a-z..
then manual sort a few items to the top of the list..any suggestions?
i have a pivot table and if i select my headers i have the availability to sort a-z and z-a plus manual ...manual says to drag the item where i would like it...i have tried various ways to do this but am stumped. i have tried the excel help database..they reference manual sort but really give no explanation.
scenario..
i want to sort a-z..
then manual sort a few items to the top of the list..any suggestions?