What are macros used in excel?
Macros are bits of programming commands that you can put together and save to to a shortcut name so that you can run those commands again whenever you want. For example, if there are several formatting steps you want to do over and over again, instead, of doing those steps manually every time, you can record those steps in a macro, and just run that macro to run all those steps automatically. In Office applications (Excel, Word, etc.), there are 2 ways to create macros. The easiest way is to use the Macro recorder. You start by creating a new macro by naming it, then the recorder starts. You then perform all your work that you want repeated and the recorder will record all your actions. When you’re done, stop the recorder. Next time you can run that macro and those same actions you made will be made automatically. The other way is to write out the macro in Visual Basic yourself. You would do this if the Macro recorder isn’t able to record an action you want to do or to create some new
