Common Uses for Macros

Microsoft Excel 2002 comes with dozens of built-in, timesaving features that allow you to work faster and smarter. Before you decide to automate a worksheet task with a macro, make sure there is not already a built-in feature that you can use to perform that task. Consider, however, creating a macro when you find yourself performing the same series of actions over and over again or when Excel does not provide a built-in tool to do the job.

Macros enable you to automate just about any part of your spreadsheet. For example, you can automate data entry by creating a macro that enters headings in a worksheet or replaces column titles with new labels. Macros also enable you to check for duplicate entries in a selected area of your worksheet. With a macro, you can quickly apply formatting to several worksheets, as well as combine different formats, such as fonts, colors, borders, and shading. Even though Excel has an excellent chart facility, macros are the way to go if you wish to automate the process of creating and formatting charts. Macros will save you keystrokes when it comes to setting print areas, margins, headers, and footers, and selecting special print options for printouts.

0 0

Post a comment