Microsoft%20Excel%20Interview%20Questions%20and%20Answers
Question: How you can disable the automating sorting in pivot tables?Answer:To disable the automating sorting in pivot tables, Go to > “More Sort Options”> Right Click “Pivot table” > Select “Sort” menu > Select “ More Options” > Deselect the “ Sort automatically when the report is created”. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?