Macros

Imagine you are to present your lesson to 10 different sections simultaneously. Hard, right? In these kinds of situations, you can make duplicates of your lesson and present it to the classes in order for you not to do the same thing over and over again if you want the shortcut. But if you want the long run, suit yourself. We can do these kinds of shortcuts in Microsoft Excel with the help of Macros.

Macros ( in real life )

One of the more powerful, but seldom used function in Microsoft Excel, Macros are shortcuts that can be used, are efficient and provide an ideal way of making repetitive tasks many times without writing a single line of code.

 

In order to do this, you must:

1. Open Developer options in the Ribbon
2. Click Record Macros
3. Name the macro and the shortcut key
4. Once the Macro is recording, do the things that you want the macro to record.
5. Press the Blue box located in the lower left corner of your workbook once you are done.
6. Press the assigned key for that macro to activate.
7. i