• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Introducing Macros

After you have worked with your Excel documents for a while, you will probably discover some series of actions you perform repeatedly. While many of these actions, such as saving your changes or printing, can be accomplished quickly, some sequences involve many steps and take time to accomplish by hand. For example, you might want to highlight a number of cells in a worksheet to emphasize an aspect of your data. Rather than highlight the cells by hand every time you present your findings, you can create a macro, or series of automated actions, to do the highlighting for you.


The best way to get an idea of how macros work is to examine an existing macro. To do that, on the Tools menu, point to Macro, and click Macros to open the Macro dialog box. You can also open the Macro dialog box by pressing


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint