

Show/Hide the Ribbon completely (including the tabs and the Quick Access toolbar)

Show/Hide the Ribbon while keeping the tabs visible Important Keyboard Shortcut to Show or Hide the Ribbon What it Does Note: The methods that I have covered in this tutorial will also work in other Office apps such as Microsoft Word or PowerPoint. You can also do the same thing by using the keyboard shortcut Control + Shift + 1 In Windows you select the File tab, then you click Options, and choose the Customize Ribbon tab.As soon as you do this, the ribbon will stop showing any worksheet area would expand so that more rows are shown on the screen. If you use Excel on a Windows computer in addition to your Mac computer, then you may already be familiar with this main tabs column, as it is fairly similar if you had previously had to add the Developer tab in Windows. You can also add some other tabs that Excel has but doesn’t include by default. If you have installed some Excel add ins that have placed some new options in your Excel window, then this toolbar menu lets you remove anything that has been placed alongside your main tabs. The Customize Ribbon window that we directed you to above when you were trying to add the Excel Developer tab has a number of other things that you might need. More Information on How to Add Developer Tab in Excel Mac Our tutorial continues below with additional discussion about making this change in the Mac spreadsheet application. Now that you know how to complete the how to add developer tab in Excel Mac process you will be able to make this adjustment on other Mac computers where you need to be able to do things like work within macros or use VBA code.

Step 2: Click the Excel tab at the top of the screen, then choose the Preferences option. This article will show you how to add the Developer tab in the Windows version of Excel. These steps will only work for the Mac version of Excel. The steps in this article were performed on a MacBook Air in the High Sierra operating system.

How to Add the Developer Tab to the Ribbon in Excel 2016 for Mac (Guide with Pictures) 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. 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.īut 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.
