How to Enable the Developer Tab in Excel for Mac

The steps in this guide are going to show you how to add the Developer tab in Excel for Mac. We cover the steps briefly at the top of the article, then continue below with pictures of the steps.

Yield: Adds the Developer tab to the ribbon in Excel for Mac

How to Add the Developer Tab in Excel for Mac

how to add the developer tab in excel for mac

The steps in this guide will show you how to add the Developer tab to the ribbon in the Excel for Mac application so that that you can use the tools on that tab, such as creating macros.

Prep Time 2 minutes
Active Time 2 minutes
Total Time 4 minutes
Difficulty Easy

Tools

  • Microsoft Excel for Mac

Instructions

  1. Open Excel for Mac.
  2. Click the Excel tab at the top of the screen.
  3. Choose the Preferences option.
  4. Select the Ribbon & Toolbar option.
  5. Check the box to the left of Developer in the right column.
  6. Click the Save button.

Notes

When you are adding the Developer tab in Excel for Mac, the Main Tabs column on the Ribbon & Toolbar menu lets you edit or remove some of the other tabs as well. If there is something that you want to add, or something that you never use, it's possible to edit the ribbon as needed.

Excel 2016 for Mac, like all of the other more modern versions of the Excel application, employs a series of tabs at the top of the window that let you navigate through the various settings and tools in the program.

But there is one useful tab that isn’t included in the default set of tabs, and you might be looking for one of the items on that tab if you are trying to do something like create or run a macro. Our tutorial below will show you how to add the Developer tab in Excel for Mac so that you can gain access to the options that it includes.

How to Add the Developer Tab to the Ribbon in Excel 2016 for Mac

The steps in this article were performed on a MacBook Air in the High Sierra operating system. These steps will only work for the Mac version of Excel. This article will show you how to add the Developer tab in the Windows version of Excel.

Step 1: Open Microsoft Excel for Mac.

Step 2: Click the Excel tab at the top of the screen, then choose the Preferences option.

open the excel preferences menu

Step 3: Select the Ribbon & Toolbar option.

open the ribbon and toolbar menu

Step 4: Check the box to the left of Developer in the right column, then click the Save button at the bottom-right corner of the window.

how to add the developer tab in excel for mac

Would you like to save as a different type of file when you create new spreadsheets? Find out how to change the default save type in Excel for Mac if you would prefer to save as an .xls or .csv file when you create new files.

solveyourtech.com newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.