1. Computing

Discuss in my forum

Ted French

Excel Macro Tutorial

By , About.com GuideMay 10, 2013

Follow me on:

When you find yourself repeatedly performing the same actions or tasks in a spreadsheet, it might be time for you to create a macro.

A macro is a recording of each command and action you perform to complete a task. Then, whenever you need to carry out that task in a spreadsheet, you just run the macro instead.

Complex macros are usually created in Excel with the Macro editor. Simpler macros can, however, be created using the Excel macro recorder.

To find out how to create a macro using the macro recorder in Excel, read the step by step Excel Macro Tutorial.

Related Tutorial
Comments
August 2, 2008 at 7:44 pm
(1) beaultylype says:

Thank you

June 25, 2010 at 7:49 am
(2) chris says:

thank you very much..i think am now ready to do the exam

August 23, 2010 at 3:31 am
(3) SIVARANJANI says:

THANK YOU

August 27, 2010 at 1:58 pm
(4) Green says:

thanks for such nice info

August 27, 2010 at 2:02 pm
(5) Webdesignseo says:

cool info

August 27, 2010 at 2:06 pm
(6) Webdesignseo says:

thanks

December 20, 2010 at 4:34 am
(7) Muku says:

I have an excel tabular column and once we filled in the details in it and run the macros I want to create a word template.
Is it possible ?

December 22, 2010 at 10:38 am
(8) richmond says:

I’m very glad i connected to this link…I think i am ready for my next task….

March 1, 2011 at 11:23 pm
(9) vinodh says:

Very useful tip…thank u

March 26, 2011 at 9:58 am
(10) reno paslah says:

Excel is art…. i like this…. your posting make inspirated to me… :-)

December 12, 2011 at 9:54 am
(11) PS says:

Exactly what I was looking for. Quick guide to getting Macros enabled. Thanks!

January 31, 2012 at 3:39 am
(12) Vikram Kumar Jha says:

Very useful………thanx……….

February 24, 2012 at 5:42 am
(13) Uzair says:

I want to create a macro which serve the following purpose
to imort report from an ERP and format it inot MS Excel 2007

March 9, 2012 at 9:09 pm
(14) Frank says:

Where can I find someone who will create a simple macro for Excel for me and what would be the approximate cost?

March 21, 2012 at 7:44 pm
(15) Rajesh says:

Good one. Thanks mate. Cheers

April 25, 2012 at 10:28 am
(16) Ganesh says:

Thanks a lot

May 26, 2012 at 5:10 pm
(17) Anthony says:

i have to repeat the function in recording the macro how do I do that

May 27, 2012 at 6:43 am
(18) Niranjan HS says:

This is superbbbbbbb…

July 3, 2012 at 8:01 pm
(19)  says:

You can definitely see your skills within the article you
write. The arena hopes for more passionate writers like you who aren’t afraid to mention how they believe. At all times follow your heart.

August 24, 2012 at 1:56 am
(20) beaverton says:

Pretty! This was an extremely wonderful article.
Thanks for providing these details.

September 10, 2012 at 10:10 pm
(21) annie says:

Nice. Thank You!

October 30, 2012 at 5:43 am
(22) Jinandra says:

Well written. Thanks

November 22, 2012 at 1:08 am
(23) Pradeep Kumar says:

but where is collection of macros?

November 26, 2012 at 11:00 pm
(24) Shivakumar says:

Really very helpful hints thank u

February 6, 2013 at 1:22 pm
(25) wasim says:

please help me in access

February 13, 2013 at 12:06 pm
(26) Vijay says:

well presented .. thank you

April 15, 2013 at 4:22 am
(27) chichi says:

how can save in macros? am having difficulties wen it comes to saving in macros, kindly help.

May 11, 2013 at 9:18 am
(28) Mars says:

Nice, cool, wonderfull. Can you help write macro to download data from secret spy satellite orbitting my planet (Mars). I don’t trust man people on earth! Thanks, Qwunty.

May 14, 2013 at 2:45 am
(29) Muhammad Younus says:

Thanks a lot sir,

but i want simpale one example how to use how to work how to apply.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>
Top Related Searches excel macro gp

©2013 About.com. All rights reserved.