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.

Produits Par Bayt.com

Utilisez l'Appli de Bayt.com

Communiquez avec les autres et partagez vos connaissances professionnelles

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

Recherches Populaires

More Questions Like This