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😊

Comments

How to add CC recipients in Mail-Merge

Please refer How to do a Mail-Merge in MS Office to pursue this article further. I am going to explain the steps to send personalized emails to a huge group of receipts by looping people\groups in an email CC. Though, there is no straightforward technique for doing so. But there is one trick that functions like a charm. The trick is that we will create a new outlook rule which indicates whenever we send an email with the specific subject line, it will automatically include certain group\people in the CC. Steps to create this new rule in Outlook 1. Go to Rules in the menu bar and select Manage Rules & Alerts. 2. Then a dialogue box will appear. Click on the New Rule and choose Apply rule on messages I send in the following wizard (refer to the below screenshot) and Click Next. 3. In the subsequent window, tick the first line, which says with specific words in the subject line in Step 1 and click on a specific word from Step 2 (Refer to the below screenshot). 4. On clicking ...

These instructions will allow you to save password-protected PDF attachments from Gmail to Google Drive.

Discover how to automatically save PDF attachments that require a password from Gmail to Google Drive and transform them into unencrypted versions that can be accessed conveniently washout a password. Financial statements are frequently sent by financial institutions as password-protected PDF files, including banks and credit card firms. Passwords formed from personal information, like your birthdate, Social Security number, or a special mix of details, are frequently used in these attachments. To access password-protected PDF files, you must enter the password each time. While Google Chrome allows for the permanent removal of passwords from PDFs, the manual and time-consuming nature of the process can be burdensome, especially if you have a substantial number of such attachments in your Gmail inbox. Imagine how easy it would be to have a solution that downloads all of your password-protected PDF attachments from Gmail straight to Google Drive and converts them into PDF files that aren...

How to create a webinar through Microsoft Teams with customized registration form for attendees

Microsoft Teams has a great range of features. Not only do they help us to schedule a meeting and connect with your co-workers instantly through chat or call, but also you can access your files stored on Microsoft cloud instantly when & where required. But here I am going to tell you about the feature which allows you to plan a webinar through Teams following simple steps, and you can also add customized forms for attendees to fill out to register for the webinar. I will show you how to schedule a webinar and add a response form to it for attended: 1. Start with going to your Microsoft teams and select Calendar from the left Panel. (Refer to the below screenshot) 2. Now on the right top-hand side, you can see a down arrow near the New meeting button. You will get three choices by pressing that arrow button which are Schedule meetings, webinars and live events. Please click on Webinar . 3. In the next windows, you will have several options. We will start with cre...

Influence Professionals

Search This Blog