Today, most people whose jobs involve collecting, sorting, creating graphs from calculations and perform other accurately appraised jobs, use Microsoft Excel , one of the applications that make up the Office suite. Excel can alphabetize names on a document and even can utilizar and work in Excel from a mobile iPhone. words is a tool with multiple options that facilitate your work.
How to Create and record a macro in an Excel spreadsheet? | What it is a Macro and usefulness?
< div class="RCTRL">
This program, although simple, contains tools and functions that are not so easy to implement if you are a beginner.
However, in this article simply learn how to create and record a macro in an Excel on both Windows and MacOS. But first, you need to know What is a macro and how it works . Here you’ll learn how.
What it is a macro and what is its use?
macro is used to automate certain tasks you perform frequently to save labor. It is an action or set of actions that can run all the times you want.
When a macro is created, the clicks of the mouse and keyboard keystrokes are recorded. Even so, after he created can make certain changes.
In other words, is a series of instructions that are saved within an Excel file to be executed when needed.
This tool is very useful because often perform the same tasks can cause us to lose valuable time we can invest in anything, therefore, the automate, by can save a lot of time.
These macros are written in a computer language called “Visual Basic of Applications” (VBA) and although clearly need to learn this language, is very simple and here learn to do .In addition, the these options, Microsoft also offers other functions and can learn from your official web site .
How to create and record a macro in Windows?
To create a macro, you do not need to do much. In fact, it is very simple and following these steps can do it quickly. First we will see how to do it using Windows .
To control the Macros and VBA tools have to place you in the “Developer” tab. If you have not yet enabled this option, it is also very easy to do.
You only need to go to the “File” , then “Options” and click on the “Customize the Ribbon” option. Once there, the “main tabs” active “developer or programmer” ready option. Paragraph
Step 2
In the section must “Code” click the “Record Macro” option. You can assign a name to the macro in the “Macro name”, you can also choose a key Shortcut in the “key Shortcut” , a description in the section with the same name. Press “OK” and start recording.
Make what you want it is recorded in the macro to do then automatically. Once you’ve finished, press the “Stop Recording” option
Step 3
Then you just have to run the macro to examine and test it. If you want to edit a macro recorded after only must go ” code” just clicking “Macros”, select the name of the macro you want to modify and press the “Edit” option.
How to create and record a macro in iMac?
If you have an Apple device, specifically macOS , here you will learn how to do the same on your device, just as easy.
Step 1
If you have not yet activated the option of the developer, you must enable it. To do this, click “Excel”, then “Preferences”, “Toolbar and Ribbon”.
Then in “Customize Ribbon” in the “main tabs” select “Programmer” and then “Save”.
list
Step 2
After the toolbar enabled “Programmer”, click “Record Macro”. Right there you can rename the macro, enter a letter abbreviated method and a description of it. Press “OK” when you’re ready to start recording.
Choose and executes the actions you want to be automated and part of your Macro. Then you just have to press the “Stop Recording” option when you are ready, the “Programmer” .
Step 3
Then you just have to try and make sure the Macro that was recorded in the right way and where you want.
If you want to edit can also do in the “Macros” section by selecting the appropriate macro name and press “Edit”.
We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
Cookie
Duración
Descripción
cookielawinfo-checbox-analytics
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checbox-functional
11 months
The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checbox-others
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-necessary
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-performance
11 months
This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy
11 months
The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.