Create a button to sort data in Excel

I have an easy way to create a one-click tool to sort information in Excel. First record your macro. Click on the Tools menu, then Macro and then Record new macro. Give the macro a name and click on OK. Perform the actions then click on the Stop button.

Click on Tools, Macro and Macros. Click on the macro once and then on Edit. Select all the text between (not including) Sub and End Sub and copy it to the clipboard. Close the Visual Basic window.

Click on the View menu, Toolbars and Control Toolbox. Click on the button icon in this toolbar and draw the button. To rename it, right-click on CommandButton Object and Edit.

Type the name and press Enter. Right-click on the button and then click on View Code. Click to insert the cursor in the blank line and paste the code from the macro. Click on the Save button and close the Visual Basic window.

Mike Goodwin

Baffled by jargon? See our free online Jargon Buster.