First create your Macro:
On the Task Bar,
Record New Macro,
A small window should open,
Give the Macro an appropriate name, like “MySort”
A small box with the word “Stop” should appear.
If it does not don’t worry, will take care of it later.
Sort your sheet in the manner you wish it to be sorted.
When you done,.
Click the “Stop” button to end the macro.
If there is no Stop button, then, On the Task Bar
Click on Stop Recording Macro
Create a button for the macro
On the Task Bar
In the small window, under “Categories”,
Scroll down and click on “Macros”
The right panel should change and there should be a smiley face next to “Custom Button”
Left click on the smiley face, hold and drag up to the Task Bar and let go.
Where, on the Task Bar, you put it is up to you. I usually place it on the far left or next to the Help button.
Click “Close” on the small window.
Next, click on the smiley face button and another window opens that reads “Assign Macro”
Find your “MySort” macro and double click and your done.