Also, be aware that the Developer tab will always be displayed in the ribbon from now on unless you either go back into Options and turn it off or re-install Excel.

First, enable the Developer tab, then create a Macro. After that, save it as an Excel Macro-Enabled Workbook for Microsoft Excel Spreadsheet and a Word Macro-Enabled Document for Microsoft Word.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.