Create Macros in Excel 2016 with Effective Way

Microsoft Excel is one of the application of MS Office suite developed by Microsoft Corporation. It is the spreadsheet used on Mac OS X, iOS and Windows operating system and Excel spreadsheet consists of various specifications including graphing tools, calculation, pivot tables, macro programming language (Visual Basic). MS Excel has different editions including MS Excel 2003, Excel 2000, Excel 2007, MS 2010, Microsoft Excel 2013, and MS Excel 2016.

What is Macros?

Macros are the small programs that operate within MS Excel and assist automate common iterative tasks. Macros are one of major feature of Microsoft Excel in 2016 on both Mac and Windows systems. By utilizing macros, user can easily save hours and boost productivity manifold.

Steps to create Macros in Excel 2016:

Step 1: Start the Developer Toolbar: First activate the Developer tab by selecting file tab under that click on “Options” then select “Customize Ribbon” and check mark the box next to “Developer” in order to write macros in Developer toolbox. Press “Ok” button then you can find the Developer Tab in the ribbon.

Step 2: On opened “Developer” tab, click on “Record Macro” option. In order to make a macro from VBE, click on “Visual Basic.” Then enter the macro code in window of the module that you like to use.

Step 3: In this step type the name of the macro on “Macro name” box. There are some condition to follow while entering the macro name are first character should be letter and followed with special characters, numbers, letters, etc. Should not use space in macro name and suppose if you use a macro name as a cell reference then you might encounter with an error message like the macro name is not valid.

Step 4: Next, from the dropdown list of “Store macro in” choose “This Workbook” and in the “Shortcut key” box enter any uppercase or lowercase letter that you like use it.

Step 5: In the “Description” box, write few lines of description about the macro and then click “OK” to start record the macro. Choose the cell where you typed your text and go back to the ‘Home’ tab to edit cell color to red, font weight to bold and font size to 18.

Step 6: In the final step, click on the “Stop Recording” button under “Developer” tab or on spreadsheet press the small square block at the bottom next to ‘Ready’ option. And, you have effectively recorded an Excel macro.