Excel macros are pretty easy to use once you enable them.
Let’s explore recording Excel macros with a detailed step-by-step guide.
To use macros, you’ll need toenable the Developer tab in Excel.
As mentioned before, this tab isn’t enabled by default.
To enable it, go toFile > Options > Customize Ribbon.
In theCustomize the Ribboncolumn withMain Tabsselected on the dropdown, tickDeveloper, and clickOK.
The Developer tab will now appear in the ribbon.
It’ll stay here permanently unless you disable it in the same window.
Click Record Macro
Navigate to theDevelopertab you just enabled on the ribbon.
In theCodegroup, clickRecord Macro.
This will open a new window where you’ll have to enter the details for your macro.
Alternatively, you might pressAlt + T + M + Ron your keyboard to bring up the macro dialog.
Input a Macro Name
Input a name for the macro within theMacro namefield.
Make it specific, otherwise, you’ll have trouble quickly identifying what the macro does in the future.
you might’t use spaces and avoid giving the macro the same name as cell references.
Click within theShortcut keybox and press the key that you want to use in conjunction with Ctrl.
It’s best if you holdShiftwhile selecting your key combination to make it part of the shortcut.
Your macro shortcut will override thedefault Excel shortcuts, if one already exists.
For example, if you chooseCtrl + Athen it’ll override the ability to select everything.
Instead, useCtrl + Shift + Asince that isn’t an existing shortcut.
Select Where to Store the Macro
Use theStore macro indropdown to choose where you want to store the macro.
The options available are:
6.
Input a Description
The final step in this window is to input aDescriptioninto the box.
Use this to describe in detail what the macro does.
Click OK
Perhaps the easiest step of all!
ClickOKwhen you’re happy with what you’ve submitted to begin recording the macro.
Perform Your Macro Actions
The macro is now recording, so perform your steps.
you could toggle theUse Relative Referencesoption on theDevelopertab touse relative referenceswhile recording.
If disabled, the cursor would move from A1 to A3.
If you slip up, stop the recording and start again.
Alternatively, you could attempt to fix it by editingthe Visual Basic utility (VBA) codefor the macro.
You have now successfully recorded your Excel macro!
you could also pressAlt + F8to open this window.
This is because your macro is stored in your personal macro workbook, which is a hidden PERSONAL.XLSB file.
To unhide this workbook, go to theViewmenu and then clickUnhidein theWindowsection.
Excel will initiate the PERSONAL.XLSB workbook.
This is a blank workbook that stores your personal macros.
Dive deeper, practice, and discover the full potential of Excel macros to elevate your data management game!
