O'Reilly logo

Microsoft Excel X for Mac OS X: Visual QuickStart Guide by Maria Langer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Macros

A macro is a series of commands that Excel can perform automatically. You can create simple macros to automate repetitive tasks, like entering data or formatting cells.

Although macros are created with Excel's built-in Visual Basic programming language, you don't need to be a programmer to create them. Excel's Macro Recorder will record your keystrokes, menu choices, and dialog settings as you make them and will write the programming code for you. This makes macros useful for all Excel users, even raw beginners.

To record a macro with the Macro Recorder

1.
Choose Tools > Macro > Record New Macro (Figure 51) to display the Record Macro dialog (Figure 52),
Figure 51. The Macro submenu under the Tools menu offers commands for working with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required