O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

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

Recording Macros

When you need to quickly automate a task, you can record a macro using the Macro Recorder. Follow these steps:

  1. Plan the actions you'll take in the macro. You may find it helpful to write them down so that you can perform them in the right sequence when recording the macro.
  2. Launch Excel if it's not running, or activate it if it is running.
  3. Set up a workbook with the conditions you need to perform the actions in the macro. For example, if the macro will move some data from one worksheet to another, enter some sample data to move, and make sure that the workbook contains a worksheet you can use as the destination.
  4. Choose Developer Visual Basic Record from the Ribbon or Tools Macro Record New Macro from the menu bar to display ...

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