I don’t know how to use Macros in MS Excel.
Can anyone tell me how to use it?
How to use Macros in Microsoft Excel
Macros record your mouse movements and clicks and help in reproducing your work automatically.
The simplest way to create a macro is by recording the same. Go to Menu bar , tools and then Macro and click on Record Macro.
You can then give a name to it save at your selected location. Now all your actions are recorded in this macro.
For eg: Say you are formatting a sheet for the purpose of printing. Go to Menu bar , tools and then Macro and click on Record Macro.
All you do is set Print area, correct margins, header and footer.After doing these adjustments, click on 'stop' on Macro menu.
Stop appears from the time you start recording. Give a name and save this macro.
Now, if you have other sheet for formatting similar to the previous one, then all you need to do is to run this macro.
All formatting, adjusting footer and header works, setting print area are now done in one single click.
To run your selected Macro you have go to tools > Macro > Macros.
You can also assign key combo to macros, Something like shortcut.
-
In Excel 2007 or 2010, you do it this ways:
-
Go to View tab > Macros > Record Macro.
-
In Macro dialog box, enter macro name and in shortcut key field , enter shortcut key with ctrl key.
-
You can then save the macro and key combination in a new workbook or existing one.
Click on OK.
How to use Macros in Microsoft Excel
Creating Simple Macro in Microsoft Excel:
-
Click on Start
-
Go to Programs
-
Choose Microsoft Office
-
Open Microsoft Excel
-
Go to Start
-
Click on New
-
Go to File tab
-
Select Save As
-
Go to Tools
-
Choose Macro
-
Select Security (choose medium option under Security Level Tab then hit OK)
-
Bo again to Tools
-
Choose Macro once more
-
Select Record New Macro
-
Enter a name for Macro Name once Record Macro pop up appears
-
Put a brief description for this macro and click on OK
-
Test the macro you created by going to File then selecting New for a new spreadsheet
How to use Macros in Microsoft Excel
I don't even know what macros in Excel is before.
Thanks Valbuena Jane!
I tried it and it works just as what you said.
I believe this will be handy in the future.
Thanks again!
