• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 31. Recording and Editing a Macro > Why Create Your Own Commands?

Why Create Your Own Commands?

Macros give you the power to create your own commands, which can save you time. Think of some of the tasks that you perform repeatedly in Excel. Macros can do these tasks for you. Following are some typical repetitive tasks that can be automated with macros:

  • Format and print a report.

  • Assist in the completion of an Excel form, such as an expense report.

  • Consolidate data from several workbooks into a master workbook.

  • Import and plot data to a chart.

  • Assign a keyboard shortcut to a frequently used command.

  • Assign a built-in command that has no built-in button associated with it to a custom button.

  • Apply your favorite AutoFormat to a range of cells.

  • AutoFit all columns on the current worksheet.

  • Create your own custom spreadsheet application.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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