O'Reilly logo

Excel 2013 All-in-One For Dummies by Greg Harvey

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

Chapter 1: Building and Running Macros

In This Chapter

arrow.png Understanding how macros do what they do

arrow.png Recording macros for instant playback

arrow.png Using the relative option when recording macros

arrow.png Running the macros you’ve recorded

arrow.png Changing the macro security settings

arrow.png Assigning your macros to the Ribbon and Quick Access toolbar

Macros enable you to automate almost any task that you can undertake in Excel 2013. By using Excel’s macro recorder to record tasks that you perform routinely, you not only speed up the procedure considerably (because Excel can play back your keystrokes and mouse actions much faster than you can perform them manually), but you are also assured that each step in the task is carried out the same way each and every time you perform the task.

Excel’s macro recorder records all the commands and keystrokes that you make in a language called Visual Basic for Applications (VBA), ...

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