How to Display the Developer Tab in Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010
Before you add macros in Excel, display the Developer tab on the ribbon. By default, the Developer tab is not visible.
How to Create a Macro in Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010
When you’re ready to create a macro, start Excel and open a worksheet.
How to Display the Developer Tab in Excel for Microsoft 365 for Mac, Excel 2019 for Mac, and Excel 2016 for Mac
Before you add macros in Excel for Microsoft 365 for Mac or in Excel 2019 or 2016 on a Mac, display the Developer tab on the ribbon. By default, the Developer tab is not visible.
How to Create a Macro in Excel for Microsoft 365 for Mac, Excel 2019 for Mac, and Excel 2016 for Mac
When you’re ready to create a macro, start Excel and open a worksheet.
How to Run a Macro
When you want to run a macro you created in Excel, either use the shortcut you assigned to the macro or run the macro from the Developer tab. To run a macro using a combination shortcut key, open the worksheet containing the macro. Enter or select the data on which you want to apply the formatting or commands included in the macro. Then, press the key combination assigned to the macro. To run a macro from the Developer Tab, open the worksheet containing the macro, then follow these steps:
How to Change the Macro Shortcut Key
To add or change a combination shortcut key for a macro:
