Next, we will teach you how to make macros in excelIf you would like to know how to do this easily and quickly? we recommend you keep reading.
Learn how to make macros in excel.
How to make macros in Excel? Step by step
If you use Excel on a regular basis, chances are that you already identify the complex tasks that you need to perform. Complex so that you have to chain several actions in a row, such as:
Sort different sales revenue and convert it to a chart, change the colors in a header, and even apply different formulas to a set of cells.
Macros are made to save time and automate tasks that we perform one after another. If you already know what these three or four actions are that you always apply, in the same way you can turn this into a macro, that is, an order that is enabled every time you press several keys and perform several tasks automatically.
How to create and run a Macro in Excel?
The first thing you should do is open Excel, open a blank sheet and enter the "View" tab and check if the "Macros" icon exists. If it does not appear, you must go to "File", then to the "Options" section and then where it says "Customize Ribbon", here you must enable the "Macro" icon so that it appears in the " View".
To create a macro recording, all you have to do is press the «Macro» icon, enter the menus and write everything according to how it is assigned to a combination of keys that can be «Control + key» that you want to configure, remember to choose the combination of keys for the actions, and once they are recorded they will be repeated each time you apply it, such as:
If you are going to create a simple macro, you must add a heading to a blank sheet, in the columns that can be "Summary of the day, sales expenses and the total", again the macros are used in more complex actions, however , if we use this simple example it can be better understood.
Again in the "View" tab you must locate the "Macros" option and once that menu is open, you must select "Record macros", you must give this Macro a name, without spaces. Then in the "Shortcut key" section you must indicate the key that will activate this macro, such as "Control + R". Remember not to use keys that Windows uses for other functions such as "Control + C" to copy text.
Then in "Description" you must explain, what is this Macro for? When you click on "OK", the macro recording will start, you will notice that this will be the case since a record button will appear in the lower left part of Excel. From here, any action you do will be recorded within the macro.
Going back to the example, you will add a heading as we said "Summary of the day, sales, expenses and total", with a background and letter of different colors, after this you will press the macro recording button to stop said recording, and you're done. created a macro so you can save the Excel workbook and when saving it is important that you select the "Type" box and the option "Excel workbook enabled for macros", if you don't, the macro will not work.
You can now use this macro in any book in the following way: You open a blank sheet and when pressing «Alt + F8», the list of macros that you have archived will open, then you will select the one you want to use and click on «Execute» and in this way the macro recording will be added automatically. You can also activate it with the keys you have assigned as "Control + R".
If this information was helpful, do not hesitate to visit our website, where you will find more articles like this: How to make a calendar in Word Step by Step?