What are the Macros.? explain the step by step produce to record a macro
Answers
Answer:
Spreadsheets are infinitely flexible—especially in Excel, one of the most powerful spreadsheet apps. Most people use only a small percentage of their seemingly countless possibilities, however. Yet it doesn't take years of training to take advantage of spreadsheets' power and the automation magic of Excel macros.
You likely already use functions like =sum(A1:A5), the simple bits of text that add, average, and calculate your values. They're what make spreadsheets a powerful tool for crunching numbers and text. Macros are the next step: They're tools that automate simple tasks and help you get more done in less time. Here's how to unlock that new part of your Excel skill set by building your own macros in Excel.
New to spreadsheets? Start first with our Spreadsheet 101 guide—it walks you through the core spreadsheet features to help you get started using any spreadsheet app: Google Sheets, Excel, or any other spreadsheet tool.
What Are Excel Macros?
Macros are code that automate work in a program—they let you add your own tiny features and enhancements to help you accomplish exactly what you need to do, quickly with just a click of abutton. In a spreadsheet tool like Excel, macros can be especially powerful. Hidden behind the normal user interface, they are more powerful than standard functions you enter into a cell (e.g.=IF(A2<100,100,A2)).
These macros make Excel work for you. They replace actions that you do manually—everything from formatting cells, copying values, and calculating totals. So with a few clicks you can quickly replace repetitive tasks.
To make these macros, you can simply record your actions in Excel to save them as repeatable steps or you can use Visual Basic for Applications (VBA), a simple programming language that's built into Microsoft Office. We'll show you how to use both below, as well as share examples of Excel macros to help you get started.