To create a Custom Macro in Microsoft excel just follow the below steps:

1. Go to tools -> Macro -> Record New Macro : A pop up will display. Just enter the macro name and assign a short cut key to it. Select “Personal Macro Workbook” in “Store macro in” checkbox.

2. Next do all the stuff you wanted by the macro to do manually.

3. Finally Go to tools -> Macro -> Stop Recording.

That’s it your Macro is Created.

Example:

We will create a Macro for Cell Merging:

Step 1:  Go to tools -> Macro -> Record New Macro : Provide the below details:

Macro Name : Cell Merge

Key                : Ctrl + Shift + M (You can provide your own key)

Step 2: Select any two cells -> Go to Format -> Cells -> Click on Alignment -> Select Merge Cells Check box and Click Ok.

Step 3: Go to tools -> Macro -> Stop Recording.

Step 4: While closing the excel, it will ask to save the key, click on Yes.

That’s it from now onwards we can use Ctrl+Shift+M for Cell Merging.

Hopefully this may be helpful in many situations like creating Test Cases, building Formula’s etc