Record a Macro in Excel – Instructions and Video Lesson

Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.

Record a Macro in Excel: Overview

You can well record a macro in Excel. Macros are belittled programs that record your actions as you perform a job in Excel. The actions are then saved as a ocular Basic Module, which is a type of program. When you run the macro later, it repeats your keystrokes and thus repeats your actions. This is why macros are great for automating insistent tasks .
For case, assume you wanted to place your diagnose and your company ’ south information in the upper-left cellular telephone of a worksheet. You could record a macro in Excel to save your keystrokes as you create it once and then run the macro in the future to repeat the demand same keystrokes you entered. This lets you instantaneously repeat the same process again .
While you can see advance options for creating macro on the “ Developer ” tab key in the Ribbon if it is enabled, you can besides use the “ Macros ” button group on the “ View ” tab in the Ribbon to record a macro in Excel and playback basic macro. In this lesson, we will examine how to record a macro in Excel using the commands found within this button group in the Ribbon .
To record a macro in Excel, click the “ View ” check in the Ribbon. then click the “ Macros ” drop-down button in the “ Macros ” button group. From the drop-down menu that appears, select the “ Record Macro… ” command to open the “ Record Macro ” dialogue box. In the “ Record Macro ” dialogue box, enter a name for the fresh macro into the “ Macro name ” text box. Macro names can not contain spaces. Its first gear character must besides be a letter.

Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.

Record a Macro in Excel – Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.

next, select the name of the workbook to which to attach the macro by selecting its name from the “ Store macro in : ” drop-down. If you do not change it, it defaults to saving the macro into the current workbook. This is crucial because a macro can only be run if it is attached to an candid workbook or stored in the “ Personal Macro Workbook, ” which is a obscure workbook that opens by default in Excel .
To create a custom keyboard shortcut for the macro to use in junction with the “ Ctrl ” key, type the hope shortcut samara letter into the text box next to the “ Ctrl + ” label. If you do this, ensure you don ’ thymine overwrite an existing shortcut ! For exemplar, the shortcut character of “ phosphorus ” is a bad choice because “ Ctrl + P ” is already a keyboard shortcut for the “ Print ” command. If you aren ’ metric ton familiar with the keyboard shortcuts, it may be better if you don ’ triiodothyronine assign one. To start recording your macro ’ sulfur actions, click “ OK. ”

Record a Macro in Excel - Instructions and Video Lesson: A picture of a user changing the cell references recorded within a macro in Excel by using the “Use Relative References” toggle command.

Record a Macro in Excel – Instructions and Video Lesson: A picture of a user changing the cell references recorded within a macro in Excel by using the “Use Relative References” toggle command.

You can adjust the types of cell references you make when you record a macro in Excel. For exercise, assume that when you began recording your macro, your “ active cell ” was cell A1. From there, you clicked into cellular telephone D1. When Excel records you doing that, it can either record that natural process as a proportional reference or an absolute address. That military action, if recorded using proportional references, would make the “ active cellular telephone ” move four cells to the right of whatever cellular telephone it was in when you started to play the macro. If you recorded it in absolute terms, it would constantly move to cell D1 from wherever cell you had selected as the “ active cell ” when you started to play the macro .
To enable relative cell referencing when recording a macro, click the “ Macros ” drop-down push button in the “ Macros ” button group. then select the “ Use Relative References ” dominate to turn it on. By default option, Excel macro use absolute cell references. To switch second to absolute cell referencing when recording a macro, click the “ Macros ” drop-down button in the “ Macros ” group. then select the “ Use Relative References ” command again to turn it off.

After you record a macro in Excel, click the “ View ” tab in the Ribbon. then click the “ Macros ” drop-down push button in the “ Macros ” button group. then select the “ Stop Recording ” command to stop recording the macro. besides, remember that if you want to save a workbook that contains macros in Excel, you need to select the “ Excel Macro-Enabled Workbook ” choice from the “ File type : ” drop-down in the “ Save As ” dialogue box .

Record a Macro in Excel: Instructions

  1. To record a macro in Excel, click the “View” tab in the Ribbon.
  2. Then click the “Macros” drop-down button in the “Macros” button group.
  3. Then select the “Record Macro…” command to open the “Record Macro” dialog box.
  4. In the “Record Macro” dialog box, enter a name for your new macro into the “Macro name” text box.
  5. To create a custom keyboard shortcut to use in conjunction with the “Ctrl” key, type the desired shortcut key letter into the text box next to the “Ctrl +” label. If you decide to do this, make sure you don’t overwrite an existing shortcut!
  6. Select the name of the workbook to which to attach the macro from the “Store macro in:” drop-down.
  7. To record your macro’s actions, click the “OK” button and then perform the actions to record.
  8. To use relative cell referencing when recording a macro, click the “Macros” drop-down button in the “Macros” group.
  9. Then select the “Use Relative References” command.
  10. To switch back to absolute cell referencing when recording a macro, click the “Macros” drop-down button in the “Macros” group.
  11. Then select the “Use Relative References” command again to turn it off.
  12. To stop recording the macro, click the “View” tab in the Ribbon.
  13. Then click the “Macros” drop-down button in the “Macros” button group.
  14. Then select the “Stop Recording” command.

Record a Macro in Excel: Video Lesson

The take after television lesson, titled “ Recording Macros, ” shows how to record a macro in Excel. This video recording lesson is from our dispatch Excel tutorial, titled “ Mastering Excel Made Easy v.2019 and 365. ”

Related Posts

Leave a Reply

Your email address will not be published.