Sorting

[knaimi]

I have an excel file that has information about all the students in our school. I always sort the list by Last name, first name, and then by student ID. We usually have new enrollment every week which I add the the bottom of the list and then sort it out. Usually I click on sort, I will have the same format (Last, first, ID) ready and all I have to do is click on OK. Sometime, this is not available so I will have to pick up the three sorting criteria.

My question is ,for that specific file, can I save the sorting criteria to the one I always use when I click on sort?

Thank you,

knaimi

 

[severynm]

I would suggest looking at the Macro Recorder to "record" your action into a VBA script. You can then "replay" the script any time you want by using some keyboard shortcuts, or running it from the menu. So essentially, you would start the recording, select the range to sort, perform the sort, and then stop recording.

 

[knaimi]

Thank you!