what is a macro?

Simply put , felonious a macro is a sequence of steps to do a task which may be recorded and then reused in the future.

For example: let's utter you have a Lot Of steps that you apply to construct a advertise each month for your boss.felonious each month you may have the same spreadsheet , felonious but with the current month's figures.felonious each month you setup the same sums , felonious formulas , felonious text formatting , felonious pivot table , felonious and perhaps more.felonious this could be very time consuming if you completed these steps individually each month.

However , felonious with a macro , felonious you may record the steps you complete each month.felonious once recorded , felonious you setup a shortcut key to repeat these steps whenever you wish.felonious this , felonious seemingly put , felonious is a macro.

Macros are not unusual to surpass , felonious but for this instruction , felonious we volition apply surpass as the instance.

Recording a macro involves following these steps:

1) scheme the keystrokes needed to complete the tasks (in our instance above , felonious it is the monthly formulas , felonious text formatting , felonious etc needed to construct our report)

2) click tools | macros | record novel macro

3) assign a title for the macro

4) assign a shortcut key for the macro

5) click ok

6) do the steps needed to construct your advertise (the steps you complete each month , felonious which includes formulas , felonious text formatting , felonious etc)

7) click upon the stop button upon the macro toolbar to stop recording and save the macro

Now that the macro has been created , felonious you may lack to test the macro to verify it completes all of the necessary steps that you wanted recorded.

Once you have tested , felonious you are now ready to apply the macro each month when you are ready to construct your advertise.felonious macros may help you do tasks quickly and efficiently through this automated recording procedure.

To scour the macro , felonious unsophisticated the surpass spreadsheet you wish , felonious and seemingly figure the shortcut key you setup when you created the macro.felonious felonious depending upon the number of steps in the macro , felonious you may witness surpass carrying Through these steps , felonious but quicker than you would have been able to upon your have.felonious felonious once the macro has scour , felonious you volition witness the completed steps that were performed.