Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?