Course Content

Course Content

Description

How to use Macros in MS Excel

Now we will see that how we can use macros in MS Excel. Suppose if we want to perform certain operation like changing the font style or making them bold or underlining them or changing their background color to any cell than we need to perform certain steps for that.

What if we need to do such kind of thing for or many cells. There we use macros option.

Macros is a series of step recording which can be replaced by particular icon or keyboard shortcut.

Now suppose if we want to make any macro of ours than we can do that by creating a macro.

For that we will first right click on our status bar and then we will see certain options of status bar, we will use macro recording option. We can also find it in our VIEW tab.

As we open it we will first asked to name our macro, and then set any particular shortcut key for it. Then we will ask to set the storing location of our macro, like for this particular excel sheet or throughout our MS EXCEL. And at last some description will be asked.

Adding description is important because whenever other user of our team or group is working on this particular excel sheet then he/she can understand that why this macro was made for.

And then when we finish adding our macro we will be able to see a recording sign in our status bar, which shows that your macro is being recorded.

Now from our home tab we can select our required task, like bold, fill background color, change font size or change font color etc... And then press the recording button from our status bar to stop.

Now we will apply our macro in our Excel sheet. One thing which we need to know that changes made in macro cannot be undo.

Now selecting any particular cell and pressing the shortcut key which we saved for our macro will work and change the format of that cell to our requirement.

So this is how we can use macros in our MS Excel sheet. It is a very useful function when we are working on very lengthy sheets.

FAQs

A macro is a set of computer commands that can automate some task, like calculating the total cost of an order, or generating a report. Your Macro can be saved as an Excel Worksheet, so you can use it again later on. A macro is an independent piece of work that has no effect on your work. A macro is not run automatically by Microsoft Excel. This macro will help you create a simple shortcut that will help you navigate to the Developer tab and select the Record Macro button in the Code group OR click the button in the bottom left corner of your screen that looks like a spreadsheet with a red dot in the top left corner.

macros are a way to automate a series of tasks on your computer. They can enter instructions on your behalf and perform some tasks for you. Macros help you accomplish tasks with a single click which saves time and money. They can also be used as a learning tool.Macros allow you to perform complex tasks such as automatically calculating values, creating charts and formulas. Macros can be used in many ways including automating a task, notifying a person when something happens, or scheduling a meeting. The most common use cases of macros are the following: * Automate a tedious task with Excel automation * Save time with Excel automation * Schedule tasks with Excel automation * Notify someone when an event happens in Excel

When you need to write a macro in Excel, you need to start by opening the Excel workbook. Then, you'll have to click on the Developer tab. This button is located in the top-left corner of the screen. Next, you'll see a drop-down menu with two options: Macros and Visual Basic for Applications (VBA). Macros are written using VBA, which are short commands that are compiled into machine code by Microsoft Office. Excel macro commands can perform tasks like adding values or formatting cells. These commands will execute automatically without user intervention after it is compiled into machine code.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
297K+ Downloads
App Download Section Circle 1
4.5 Rating
App Download Section Circle 2
10K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere