New Posts
Home / Computer 4 Beginners /  Introduction to Microsoft Excel Macro

 Introduction to Microsoft Excel Macro

 Introduction to Microsoft Excel Macro.

One of the most Microsoft Excel powerful feature that is called excel Macro. Macro is a way to automate your work.

excel macro

Let’s start with a simple idea.

Now if you have ever found suffering the repeating the same steps over and over again or may be adding the same contents in your document. Here you have to consider macros that you will do a once and never have done the again.

Example:

There is a word(text).

You want to apply background color yellow.

Also, you want to apply Bold, Italic, Underline and font color also and now same you need for other text so you repeat same steps again and again for avoiding this you use Excel macros.

In excel macro concepts come begins first of all the idea you have identified sequences of steps that you would like to automate if we can press key stroke short cut and have all the sorting, filtering, saving, printing, be done with a few seconds. This saves real time.

In Microsoft excel, the macros are typically created after you have identified sequence. The feature is called a macro recorder. You go to actually steps. All are stored in saved. The Later time you can press key stroke key shortcut or may be by way the new button.

Up at quick access toolbar then you will press that button, cause the macro happens and may be even icon the worksheet.

  • Creating a simple macro.
  • Running a macro.

Creating a Simple Macro.

After identifying steps you would like to record current in macro.

Suppose we want to apply steps.

B.

I.

U.

Font color yellow and background color black.

It is time to begin and time to record the macro.

If you right click on status bar bottom of the screen. There are many checks I mean commands here.

 Introduction to Macros

Let’s start the process recording the macro.

2 Introduction to Macros

For recording the macro click on the macro button which is shown in above button.

Or.

View Tab.

Macros.

Record Macros.

3 Introduction to Macros

This will open Record Macro Dialogue Box.

4 Introduction to Macros

B.

I.

U.

Font color yellow and background color black.

Click on any text.

Do above actions.

Stop the Macro.

View.

Macro.

Stop Macro.

stop the macro

highlight cells

Run the Macro.

Select Text.

Type required the key short cut.

Or.

View.

Macro.

View Macro.

view macro

8 Introduction to Macros

Running a Macro.

Use Macro as Command and icon.

Right, click on quick access toolbar.

Customize the quick access toolbar.

9 Running a macro

10 Running a macro

Only I see macros select that macro which we have to create previously.

11 Running a macro

12 Running a macro

13 Running a macro

Now you see the quick access toolbar, macro has been added to the image.

14 Running a macro

Select any text and apply that command.

Apply Maco on any Shape.

Insert.

Shape.

Select shape.

Draw on Screen.

Right, Click on shape.

Assign Macro.

Click you created a macro.

Ok.

 Apply Macro on any Shape.

Select text.

Click on shape.

Macro will be applied.

 

About imran

My Name Mohammad Ramzan Bhutto. Live in District Jacobabad, Sindh, Pakistan. I have started blogging on Information Technology, my selected areas are Online Business, Digital Marketing, Make Money Online.

Check Also

Access Database relationships

How to use Microsoft Access Database Relationships.

How to use Microsoft Access Database Relationships. In this article, we will learn Access Database …