Subscribe To
This Site

Record a Macro

Record a macro is the simplest way to enhance the power of excel. And you do not have to know programming to make use of macros to enhance the efficiency of excel. We are going to record a macro that will format the cell with a number format that is not provided by any of the Excel icons. To make it complete, we need to create an icon and assign the macro to the icon, First let us show you how to record the macro and save it such that you can use it in all the worksheets.

1. Enter a number in the active cell.

2. Go to the menu, click on Tools --> Macro --> Record New Macro.

3. Enter a name for the macro e.g. Custom_Num_Format (note: spaces are not allowed), select to store the macro in “Personal Macro Workbook”.

4. Click on the right mouse button, select format cell.

5. Go to the Number Tab.

6. Select the number category, check the box “Use 1000 Separator (,)”, select the negative number format with bracket and coloured red.

7. Click OK to exit Format Cell Dialog box.

8. Stop the Macro Recorder by click on the pop up box. Alternatively, goto to menu, click on Tools --> Macro --> Stop Recording.

9. Close the workbook without saving.

10. Close the Excel Application. Excel will prompt you whether you want to save the changes made to the personal macro workbook. Click Yes.

11. Re-launch Excel.

After you record a macro, implement it using the guide here.

footer for record a macro page