How can we disable the automatic sorting in pivot tables in ms excel ?

Question

Sharon Urbanes-Silao · Answer

Go To > More Sort Options > Right Click ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically

Faridullah Khan · Answer

To disable automatic sorting in pivot tables:

Go To > More Sort Options > Right Click ‘Pivot tables’ > Select ‘sort menu’ > select ‘More Options’ > deselect ‘Sort automatically

NEHA NEGAR ALAM · Answer

For this yo first need to select the heading click on sort under pivot table options, then click more options, next click off Autosort , and then try to save the file.

Hasantha Wickramarathne · Answer

Turn Off Pivot Table Autosort.

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

How can we disable the automatic sorting in pivot tables in ms excel ?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة