Instructions for creating Macros in Excel

Avoid repeating simple manipulation steps, or formatting data in Excel, you can create macros to use as needed. Macro temporarily understands that it records all operations from the time you create until you stop recording Macro. Then when you need to repeat that operation with another location, you can use the Macro, at this time Marco will automatically perform the operations that you have recorded.

Macros help you save time when performing repetitive steps in Excel.

You can refer to how to create and use macros in Excel in the following article.

Display the Developer tab on the toolbar

Macro in the Developer tab, if the Developer tab does not appear on the Excel file, you can set it to display the Developer bar as follows:

1. Select File -> Options .

Instructions for creating Macros in Excel Picture 1

2. On the left menu of Excel Options select Customize Ribbon , then check the box before Developer and select OK .

Instructions for creating Macros in Excel Picture 2

Create Macro

Step 1: Select the Developer tab on the toolbar (Ribbon) -> Record Macro .

Instructions for creating Macros in Excel Picture 3

Step 2: The Record Macro dialog box appears , you name it in Macro name (unsigned name), description for Macro in Description . You can create shortcut keys for this Macro in the Shortcut key .

Then click OK to start creating the Macro.

Instructions for creating Macros in Excel Picture 4

Step 3: Select the data box and you perform the operations you want to create for the Macro. For example, manipulate bold letters, white letters, and fill a black background with cells.

Instructions for creating Macros in Excel Picture 5

Step 4: After the operation is complete, select the Developer tab -> Stop Recording to stop the Macro.

Instructions for creating Macros in Excel Picture 6

Similarly, you create the macros needed for working with Excel spreadsheets.

Step 5: Use the Macro.

To use macros, select the data cells to apply macros, then select the Developer tab -> Macros .

Instructions for creating Macros in Excel Picture 7

In the Macro dialog box, select the Macro name to apply in Macro name and select Run .

Instructions for creating Macros in Excel Picture 8

The data box will be edited according to the Macro you choose.

Instructions for creating Macros in Excel Picture 9

With the simple way of creating macros, you can create Excel files macros suitable for your repetitive operations when you use Excel. Using macros will reduce the working time to increase your productivity. Good luck!