QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Create Macros in MS Excel 2016?

By Neha T Leave a Comment

Suppose you are working on Excel, and repeatedly you have to perform the same actions. Then you can create a macro for that and use it as many time in the worksheet. A macro record the actions, it can be a mouse click, keystroke, or modification in a font, etc. Creating macro saves time. So let’s move towards the steps of How to Create Macros in MS Excel 2016?

Steps to Create Macro in MS Excel 2016:

Step 1:  Open an Excel worksheet on your screen in which you want to create a macro. Now, go to the View tab. Under Macros group you have a Macros drop down button click it.

how-to-create-macro-in-ms-excel-2016-step-1Step 2: Macros provide three options:

View Macros: it will show you the list of the already created macro if any.
Record Macros: this option allows you to create your macro that you can play back again.
Use Relative References: Here macros are recorded with the actions relative to the initially selected cell.

how-to-create-macro-in-ms-excel-2016-step-2As our aim is to create Macro select Record Macro.

Step 3: A Record Macro dialogue box is opened which will demand to fill the Macro name, Shortcut Key, Storage location of the macro.
In the image below you can observe that I named my macro as Highlight, remember do not use spaces while naming a macro. Then in Shortcut key, the Ctrl key is constant in every shortcut key, I wanted to make the shortcut as Ctrl +H i.e.  h in upper case to make a shortcut key. Hence I pressed Shift + h that’s why Shift + H get append to Ctrl.

Next, comes Store Macro in, a drop down box. It provides you three options:

Personal Macro Workbook: Select this if you think that the created macro has wider applicability to the other workbooks also.
New Workbook: Select this if you want the macro to be applicable to the workbooks that you will create newly.
This Workbook: Select this when you feel that only the current workbook will require this macro.

how-to-create-macro-in-ms-excel-2016-step-3For now, I have selected This Workbook. Then Click OK.

Step 4: As soon as you click OK, the recording has started. Click a cell (1) to which you want to use to create a macro. Then perform the action to record a macro. Like I selected (2) the Font size 12, Font Style Bold, Italic, Font Alignment, Colour of text and background. Now when you performed the desired actions, to stop recording click on the box beside Ready (3) that appears at the left bottom of the worksheet.

how-to-create-macro-in-ms-excel-2016-step-4Step 5: Now, it’s time to use the macro. You can simply select a cell to which you want to apply macro. Then press the shortcut key to apply macro. You can also go to the Macros button in the View tab and visit View Macros and then select the macro you want to apply then run it.

how-to-create-macro-in-ms-excel-2016-step-5Thank you. Hope the content is useful. Keep reading.

You Might Also Like:

how-to-delete-macro-in-ms-excel-2016-featured-imageHow to Delete Macro in MS Excel 2016? how-to-break-links-in-ms-excel-2016-featured-imageHow to break Links in MS Excel 2016? Create a named range in Excel feature imageHow to Create Named Range in Excel? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? enable macro featured imageHow to Enable Macros in Excel 2016? how-to-create-links-in-ms-excel-2016-featured-imageHow to create Links in MS Excel 2016? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? How to create and execute Macros in MS WordHow to create and execute Macros in MS Word

Leave a Reply Cancel reply

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

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Change Default Font in MS Word
  • How to Fade Out Music or Audio in PowerDirector?
  • How to Merge Cells, Columns & Rows in Excel?
  • How to create a “Google Apps for Work” account
  • How to Mute and Unmute in Zoom Meeting?

Copyright © 2023 · QueHow · Contact Us