Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Recording macros in excel is a method where excel records our every step and then it is saved, when required excel automatically runs the same steps performed by the user in the exact same fashion, recording macros can be accessed from the view tab and in the macros section we will find the option for record macros.
Record a Macro Excel (Table of Contents)
How to Record Macro in Excel?
A macro is a recording of our routine steps in Excel that we can replay using a single button, which with time become boring and tedious for us to perform. Examples are
- Preparing a sales report in the required format for management.
- Formatting the data in the required data format so that the same can be uploaded on the required site.
To record a macro in excel, we can use either View Tab or Developer Tab.
Steps to Create Macros in Excel
Let us look at the steps to record macros in excel using an example.
Suppose, we need to format a specific report on a daily basis and formatting takes a lot of time like applying borders, making headlines bold, apply background color to header row and color etc.
Now before starting our job to format report, we will start recording. To start recording macros in excel the steps, which we will perform,
Step 1 – we need to go to Developer Tab -> Code Group -> Record Macro Command.
Step 2 – We will rename the macro with ‘Formatting’. There should not be any space while naming the macro.
Step 3 – We can assign the shortcut key to Macro so that we can also just press the single shortcut key to run the macro.
Step 4 – As we want that this macro should work only in this workbook, then we will choose ‘This Workbook’ for Store macro in.
Step 5 – In ‘Description‘, we need to write properly about what macro does.
Now as the ‘Record Button’ has changed to ‘Stop Recording’ in code group.
It indicates that whatever we will do now, will be created in the macro. We need to activate ‘Use Relative References’ if we want that if we have selected any other cell than a now selected cell, then macro should work accordingly.
After recording all the steps required for formatting, we will ‘Stop Recording’. Now we can use the shortcut key ‘Ctrl+Shift+F’ to apply recorded formatting.
Suppose, we have some data to be formatted in the same way.
We just need to press ‘Ctrl+Shift+F’ for formatting instead of performing many commands after selecting ‘A1′.
However, there is a limitation of the macro recorder that is the code of macro recorder is full of code that is not really needed.
Things to Remember
- If we download an Excel file with .xlsm extension (Macro enabled Excel sheet), then we must confirm that it came from a trusted source and if we create any file with macros, we should save the file with .xlsm extension.
- While creating a macro in excel, do not use ‘AutoSum’ function to get the sum, as it will hard code the formula. Instead, type formula with a single dollar sign, such as =SUM(E$2: E10). When this is done, the macro recorder records the first E$2 as a fixed reference and starts the SUM range directly below the Row 1 headings. Provided the active cell is E11, the macro recorder recognizes E10 as a relative reference pointing directly above the current cell.
- We should activate ‘Use Relative Reference‘ before creating the macro in excel
This has been a guide to Record a Macro in Excel. Here we learn how to create a Macro in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –