Click OK. Go through all the clicks, tasks, and actions for your macro and record everything. Expand the same and click Stop recording to finish the task. Excel saves your script. That’s it.