The easiest way to record a macro is the button in the lower left corner of Excel looks like this:
When you click on this you will get a pop-up asking you to name the Macro and decide if you want to have a shortcut key. Also, asks where to store the macro and for a description. You can choose any ...
