• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Excel Tutorials

Microsoft Excel Tutorials

  • Home
  • Tutorials
  • Learn
    • Formulas
    • Power Query
    • Errors
    • Videos
    • Charts
    • Shortcuts
    • Pivot Tables
    • Macros
    • Basics
    • Analysis
  • 240+ Excel Shortcuts
  • Privacy Policy
You are here: Home / Macros / 4 Simple Steps to Use Macro Recorder in Excel
4 Simple Steps to Use Macro Recorder in Excel

4 Simple Steps to Use Macro Recorder in Excel

posted on September 10, 2019

Use Macro Recorder in Excel (within 4 Steps)

Sometimes everyone thinks to complete some steps automatically in Excel so that time can be saved. However as a VBA beginner, it’s hectic to code the exact macro for it, but I have an easy way to do this by using Macro Recorder. 

Previously: Swap Values In Excel Using Macros

Before following the procedure of this tutorial make sure you have enabled the Excel’s Developer Tab.

Macro Recorder helps to mimic each step inside the Excel even if needed in another time those steps can be reused.

First, you have to turn on the Macro Recorder then follow the given steps and then stop the Macro Recorder. To give the final touch Run the Macro and boom Excel will repeat by its own the exact same steps that you have completed now.

Following are the steps to follow:

STEP 1: first of all follow Go to Developer > Record Macro

Macro Recorder

Now continue with the default name Macro1 by clicking OK.

Macro Recorder1

STEP 2: after first step it will automatically start to record so now you have to do:

  • Select a Cell (as I have selected A2  cell in my example to show you)
  • Then Click Bold 
  • And Click Italic
  • After that select the Green colour from highlight colour options
Macro Recorder2

In last of second step Go to Developer > Stop Recording

Macro Recorder3

STEP 3: if you want to try out the macro in action then you have to select the rest of other cells on which you need to apply the actions of the macro.

Then Go to Developer > Macros

Macro Recorder4
Ensure that Macro1 is selected before clicking on Run.

And within a click first two steps are automatically applied to other cells.

STEP 4: To check how it looks after completing

Go to Developer > Visual Basic

Macro Recorder5

After that in the last step Go to Modules > Module1 to see the code that does the following in your work: 

  • Setting Bold
  • Italic
  • and filling the colour with Green
Macro Recorder6

Filed Under: Macros Tagged With: excel macros, Macro Recorder, Macro Recorder in excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Download 240+ Shortcuts

Microsoft Excel comes with varieties of keyboard shortcuts which are stated below with excel shortcut name and its keys for Windows and Mac.

Categories

  • Basics
  • Formulas
  • Pivot Tables
  • Charts
  • Power BI
  • Analysis
  • Shortcuts
  • Macros
  • Add-Ins

Recent Comments

  • Olivia on Convert Formulas to Values in Excel
  • Pkv on How to Insert Comment In Power Query Steps?
  • Rahul on How to Insert Comment In Power Query Steps?
  • David on How to Insert Comment In Power Query Steps?
  • sofia on How to use Workday Formula in Excel?

Footer CTA

Get Weekly Updates in your mailbox

Get Started Now

Copyright © 2021