---
title: "What is the use of a macro in excel?"  
description: "What is the use of a macro in excel?"  
author: "Steilla Mitchel"  
published: 2022-03-25  
canonical: https://answers.mindstick.com/qa/96528/what-is-the-use-of-a-macro-in-excel  
category: "troubleshooting"  
tags: ["troubleshooting", "excel"]  
reading_time: 2 minutes  

---

# What is the use of a macro in excel?

What is the use of a [macro](https://www.mindstick.com/blog/10922/objective-c-macros) in excel?

## Answers

### Answer by Hitesh Vohra

- If you have repetitive chores in [**Microsoft**](https://answers.mindstick.com/qa/95988/is-the-new-microsoft-edge-browser-a-copy-of-google-chrome) Excel, you can record a macro to automate those operations. A **macro** is a single operation or a sequence of activities that you can repeat as often as you wish. You're recording your mouse clicks and keystrokes when you make a macro. You can alter a macro after you've created it to make minor adjustments to how it operates.
- The Developer tab, which is hidden by default, contains macros and VBA tools, therefore the first step is to enable it. See the Show the Developer tab for further details.
- Make a macro. Click **Record Macro i**n the Developer tab's Code group.
- Optionally, in the Macro name box, type a name for the macro, a shortcut key in the Shortcut key box, and a description in the Description box, then click OK to begin recording.
- Carry out the tasks you want to automate, such as typing boilerplate text or filling in a data column.
- Click Stop Recording on the Developer tab.

\

**Read More: [How many data formats are available in Excel? Name some of them.](https://answers.mindstick.com/qa/96533/how-many-data-formats-are-available-in-excel-name-some-of-them)**


---

Original Source: https://answers.mindstick.com/qa/96528/what-is-the-use-of-a-macro-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.