How to Record and Use a Simple Macro (Excel)
A Macro is just a recording of keystrokes. It can be used for an unlimited amount of tasks. The best thing to remember when recording is the shorter the better. You will want to record smaller Macros that can be used in a wide variety of worksheets. You will first have to turn on the “Developer” tab to see the Macro commands. Excel will create a “Personal Macro Workbook” to store Macros in. It will be created when you record your first Macro and select ”Personal Macro Workbook”. It will automatically open any time you open Excel.