1. Computing
Ted French

Excel Macro Tutorial

By May 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
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


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:


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.

May 28, 2013 at 10:01 am
(30) Francois NDIKUBWIMANA says:

thanks very much!!

June 8, 2013 at 1:10 am
(31) viknesh kumar says:

Thankyou sir.

June 27, 2013 at 8:19 pm
(32) kalai says:

thanks thanks thanks

July 9, 2013 at 5:47 am
(33) Arnab says:

Thanx a lot!!!

August 23, 2013 at 9:11 am
(34) Saksham says:


I want to perform Vlookup using macro. How can I do that?

October 3, 2013 at 11:40 am
(35) KG says:

Hope you can help me with an Excel issue I’m having. I have a big file where in the Practice Name column entries all start with a 3 or 4 digit number, then a space, then a hyphen, then the Practice name. like this:

1233 – Dental Group Ltd

Do you know how to delete all the numbers, spaces and hyphens from the entire column leaving ONLY the practice name?

October 3, 2013 at 3:58 pm
(36) T. French says:

One way, if you can add a new column to your worksheet, would be to use the RIGHT function in the new column to remove the unwanted characters – leaving only the practice name – but the function can’t reside in the same cell as the original entry.

November 7, 2013 at 5:40 am
(37) jaman negi says:

Thanks a Lot..

December 16, 2013 at 12:54 am
(38) Mukesh gupta says:

HI sir,

I am trying create macro lots of time but I did’nt get any success.

Thank you

December 25, 2013 at 1:18 am
(39) Danish says:

hi, I want to know about macro function like some code. How to use code and function.

January 18, 2014 at 11:24 am
(40) Venkat says:

Excellent.Thanks for the explanation.

January 29, 2014 at 9:51 pm
(41) santhi says:

i would like a write a macros as part my work.I need to generate 1 report using multiple reprots.is it possible with macros?

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.