Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by jhangeer bazmi , Computer Instructor and Operator , Imran Computer College Millat Chowk
Date Posted: 2017/03/15
Sharon Urbanes-Silao
by Sharon Urbanes-Silao , Assistant Document Controller , Dalkia-EDF Middle East

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

Faridullah Khan
by Faridullah Khan , accountant , Ghayat General Transport

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
by NEHA NEGAR ALAM , INTERN , PERTS Consultancy Firm

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
by Hasantha Wickramarathne , Quantity Surveyor , KEO International Consultants

Turn Off Pivot Table Autosort.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.