Skip to main content

How to record Macro function in the excel

Macro in Excel is an incredibly valuable function that allows us to automate numerous repetitious tasks. Once a Macro is made, you can execute it as many times you want and whenever you want. This saves our time while minimizing some repetitive acts.

Below are the steps you must to follow to create a Macro

As you can record any task that you conduct often, here I am assuming an example of conditional formatting. Apparently, we continually verify for duplicate data in your report. In order to do so, you have to go to Conditional Formatting Tab >> Highlight Cell Rules >> Duplicate Values >> then you need to select which colour you want to have for duplicate entries >> once you are done, all the duplicate date will get highlighted

 Ok Now we will automate try function.

1. Go to the View tab in the menu bar and click on Record Macro (Refer to the below screenshot)


2. Once you click on that, a new window will be opened, Enter Macro Name and pick Shortcut key, enter a description if needed. In the above example, we will enter the Macro name as DuplicateEntry and Shortcut key as Ctrl + n (Refer to the below screenshot)  Press OK.

3. Right after you press OK, start performing the action that you want to automate. So in this case, we will start doing conditional formatting for the row already selected. Once done, go to the View Tab and click on Macros >>Stop Recording.  (Refer to the below screenshot)

4. Macro is prepared now. Run a trial right away. Select another row and press the shortcut you entered. In our case, we have added Ctrl + n.  So whenever we will press Ctrl + n, it will underline all the duplicate entries.

Please test this function now to automate some of your tedious and repetitive tasks😊

Labels:

Comments

Post a Comment

Popular posts from this blog

Beauty Insides- Temu- DNM Matte Long Lasting Canster Lipstick- Reviews

When it comes to enhancing our lips, the possibilities are seemingly limitless: lipstick, lip gloss, lip stain. However, in the realm of cosmetics, often the little things have the biggest effects. Now for the little capsules lip colors on Temu—the unsung heroes of the cosmetics industry. What exactly is so great about these tiny lip colors, you ask? Let's explore the wonders of these small yet powerful devices that can drastically alter your appearance. A Shade for Every Mood There are eighteen different colors in a single packet, which makes them handy in a variety of occasions. These are an extensive range of tints and finishes available in little lip colors to suit any mood or occasion. There's a tiny lip color out there waiting to match your style and express your mood, whether you want a sheer, glossy, or matte appearance. Its you who will decide how want to carry one. Affordable Luxury When comparing the pricing of these small lip colors to their full-sized equivalents, ...
Post a Comment
Read more

Unveiling the Future: Exciting New Discoveries in the Realm of Information Technology

Information Technology (IT) continues to reshape our world at an astonishing pace, and recent advancements have unveiled groundbreaking discoveries that promise to revolutionize our digital landscape. From cutting-edge hardware innovations to groundbreaking software breakthroughs, the realm of IT is witnessing an era of unprecedented progress. In this article, we will explore some of the most intriguing new discoveries that are reshaping the way we interact with technology and opening up new possibilities for the future. Quantum Computing: A Paradigm Shift Quantum computing, long regarded as the holy grail of computational power, has made remarkable strides in recent years. Researchers have made significant breakthroughs in overcoming the limitations of qubits, the fundamental units of quantum information. These advancements have led to the development of more stable and scalable quantum systems, making quantum computing a tangible reality. With their unparalleled processing power, qua...
Post a Comment
Read more

These are the top 5 factors to consider before purchasing a new phone.

New generation phones are being used for a variety of purposes, including communication, entertainment, work, education, and more. Smartphones can be used for making calls and sending texts, surfing the web, streaming music and videos, playing games, managing finances, tracking fitness goals, and much more. Additionally, many newer phones are equipped with artificial intelligence (AI) capabilities, which allow users to access a variety of AI-powered applications and services. 1.  Cost is an important factor when buying a new phone. You should consider your budget and decide how much you can spend on a phone. 2. Operating System: Most phones run on either Android or iOS, so you should decide which operating system you prefer before making a purchase. 3. Battery life: Battery life is important when it comes to smartphones, as you don't want to be constantly searching for a place to plug in your device. Look for phones that have long-lasting batteries and good power management feature...
Post a Comment
Read more