Feb22

Tagged in:, Comments:2 comments

How Macros In Microsoft Excel Can Help You

Macros in Excel help you process repetitious data sets quickly. They save you time. Anything you use Excel for that is repeated again and again is a good candidate for a macro.

The first thing you need to decide is whether the task you're doing is a good candidate for a macro. You don't want to clutter your workspace with macro buttons that you only use once in a while.

If a task takes some set-up and includes some data manipulation (i.e. mouse clicks, selections etc.) AND you do it over and over again. Daily, monthly (even hourly) or something like that is a good reason to record and use a macro.

If you're confident that this task needs a macro, then click on the cell(s) you want to work with. (I would recommend one cell and include the selection of more cells in you macro recording.)

sorted-first-row-in-excel

 

Now click on "Tools" then "Macro" then "Record New Macro".

 

click-tools-on-excel-toolbar

 

Fill out the dialog box and click "OK".

 

record-macro-dialog-box-in-excel-change-name

 

The "Stop Recording" dialog box will appear. Move it to the side if it bothers you and go ahead and perform the steps necessary to complete your "repetitive" task.

 

stop-recording-macro-dialog-box

 

When you're all done just click the "Stop" button on the "Stop Recording" dialog box.

Putting Macros On Excel Can Help

Whatever you did while the macro was recording, each step, mouse click, selection was recorded in your macro.

You can run your new macro by clicking "Tools" then "Macro" and select the name of the macro you wish to run.

When you find yourself crunching the same type of data in the exact same format over and over, macros in Excel can help you "git 'er done"!

Share

Comments

There are 2 comments (Add your comment)

+ / - all comments
  • 1 TJ- / +
    June 19, 2010 at 11:26 pm

    Hi Dnesh – Thanks for commenting. I think you might have auto-save on in Excel, but when you close normally, Excel throws the auto saved files away…

  • 2 dnesh Panchal- / +
    June 10, 2010 at 10:41 pm

    My excel saves data automatically but loses it

    Edited by moderator

Leave a comment

(required)

(required)

 me

Help

Some things to think about...

  • Please keep comments related to topic. Please be nice. Please don't spam!
  • Basic HTML tags are allowed:
    <a href> <abbr> <acronym> <blockquote> <code> <em> <strike> <strong>
  • Add your comment and click "Preview". If you're satisfied, click "Submit"
  • Just A Note: un-related or spam comments will be deleted.
  • Thanks!

Close

Back To Top

Download What?

Download Microsoft Excel of course! And all the stuff you need like worksheets and templates. How about discussion on formulas and cell tagging? Tutorials and lists of "how-to" for everything Excel. Oh yeah, there are Excel downloads too.

About