In Microsoft Excel 2016, you can use macros to automate repetitive tasks by either recording your actions or by writing custom code in Visual Basic for Applications (VBA). Here are the basic steps for using macros in Excel 2016: Method 1: Record a Macro Open Excel: Ensure that your Excel workbook is open. Display the Developer Tab: Go to the "File" tab. Click on "Options." In the Excel Options dialog box, click on "Customize Ribbon." Check the "Developer" option, and click "OK." Access the Developer Tab: Go to the Developer tab in the Excel ribbon. Record Macro: In the Developer tab, click on "Record Macro" in the "Code" group. The "Record Macro" dialog box will appear. Specify Macro Details: Enter a name for your macro in the "Macro name" field. Avoid spaces and special characters. Choose a location for your macro: "This Workbook" to make it available in the current workbook or "New Workbook" to create a macro that can be used in any new workbook. Optionally, assign a shortcut key (e.g., Ctrl+Shift+M) if you want to run the macro quickly using the keyboard. Choose where to store the macro: "This Workbook" or "New Workbook." Add a description if desired. Start Recording: Click "OK" to start recording your actions. Perform Actions: Excel is now recording your actions. Perform the actions you want to include in the macro. Stop Recording: Once you've completed the actions, go back to the Developer tab. Click on "Stop Recording" in the "Code" group. Now, your macro has been recorded, and you can run it at any time. Method 2: Write a Macro (VBA) Access the VBA Editor: Go to the Developer tab. Click on "Visual Basic" or press Alt + F11 to open the Visual Basic for Applications (VBA) editor. Insert a Module: In the VBA editor, right-click on any item in the Project Explorer (usually on the left side). Choose "Insert" > "Module." This will create a new module. Write Your Macro Code: In the module window, write your macro code using VBA. For example: vba Sub MyCustomMacro() ' Your custom code here MsgBox "Hello, this is my custom macro!" End Sub Replace the code with your specific macro logic. Run the Macro: Close the VBA Editor and return to Excel. You can run the macro by pressing Alt + F8, selecting your macro, and clicking "Run." Remember, when writing macros manually, you may need to have some understanding of VBA programming. The recorded macro method is more suitable for users who are not familiar with programming but want to automate tasks. read less