How to use Macros in Microsoft Excel

Asked By 40 points N/A Posted on -
qa-featured

I don’t know how to use Macros in MS Excel.

Can anyone tell me how to use it?

SHARE
Best Answer by Tanok Bloran
Answered By 5 points N/A #121355

How to use Macros in Microsoft Excel

qa-featured

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.

Best Answer
Best Answer
Answered By 80 points N/A #121356

How to use Macros in Microsoft Excel

qa-featured

Creating Simple Macro in Microsoft Excel:

  1. Click on Start
  2. Go to Programs
  3. Choose Microsoft Office
  4. Open Microsoft Excel
  5. Go to Start
  6. Click on New
  7. Go to File tab
  8. Select Save As
  9. Go to Tools
  10. Choose Macro
  11. Select Security (choose medium option under Security Level Tab then hit OK)
  12. Bo again to Tools
  13. Choose Macro once more
  14. Select Record New Macro
  15. Enter a name for Macro Name once Record Macro pop up appears
  16. Put a brief description for this macro and click on OK
  17. Test the macro you created by going to File then selecting New for a new spreadsheet
Answered By 5 points N/A #121357

How to use Macros in Microsoft Excel

qa-featured

Hi,

I found 2 links for your query. I hope it will work because you did not mentioned what version you are using in your Microsoft excel. These are the 2 links:

https://www.wikihow.com/Write-a-Simple-Macro-in-Microsoft-Excel

or

https://support.office.com/en-US/?legRedir=true&CorrelationId=7c91ba31-a3f5-4698-8468-c3dfeddf88f9

I hope it will work.

Teodora Skil

Answered By 0 points N/A #121358

How to use Macros in Microsoft Excel

qa-featured

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!

Related Questions