Windows - How to add macro in excel sheet, How to use a Macro in Worksheet

How to add macro in excel sheet

How to Add and use Macro in Microsoft Office Excel or Worksheet

One of the most used package in Microsoft office Excel. Macros is an exrodinary feature included in Excel, It will be ver useful when you want yourself to do the same repeated task on different cells or on excel worksheets.

The Macros record the repetitive actions and do repeat the same actions in a single click.

Steps to create macros.

Open a New worksheet -> go to Tools -> Macros -> Record new macro.
There you will find the Record Macro dialogue box

Description of fields

 - Name - Name of your macro.

 - Shortcut key - (optional - shortcut key) this has to be a letter,
      we have used S, so in our example the macro
      will run every time we hold down the CTRL key and press the S key.

 - Store macro in - This would normally be the workbook you are working on, but you
      can save macros into a personal macro workbook.

 - Description - Here you can enter a description of the macro for your benefit.

When you have finished filling in the information click the OK button to start the macro recorder.

 - You will now see the macro recording box.

 - Everything you do now in the workbook will be recorded,

 - When you have finished click on the small blue square
   within the macro recording box to stop recording.

 - To run the macro go to
   Tools -> Macros -> Macros.
   To use the macro simply select it and click Run button.

The topic on Windows - How to add macro in excel sheet is posted by - Math

Hope you have enjoyed, Windows - How to add macro in excel sheetThanks for your time