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 .
2. On the left menu of Excel Options select Customize Ribbon , then check the box before Developer and select OK .
Create Macro
Step 1: Select the Developer tab on the toolbar (Ribbon) -> Record Macro .
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.
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.
Step 4: After the operation is complete, select the Developer tab -> Stop Recording to stop the Macro.
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 .
In the Macro dialog box, select the Macro name to apply in Macro name and select Run .
The data box will be edited according to the Macro you choose.
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!