1. Technology
Send to a Friend via Email
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Macro

By

Excel Macro

Excel Macro

© Ted French
Definition:

An Excel macro is a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheet.

Macros are used to eliminate the need to repeat the steps of common tasks over and over.

Tasks such as:

  • adding or removing rows and columns
  • protecting or unprotecting worksheets
  • selecting a range of cells
  • adding the current date to a spreadsheet

In Excel, macros are written in Visual Basic for Applications (VBA).

For those who cannot write VBA code, Excel allows you to record a series of steps - using keyboard and mouse - that Excel then converts into VBA.

Related Tutorial

©2014 About.com. All rights reserved.