views
Enabling the Developer Tab
Open Excel. It's in your Start menu or Applications folder in Finder. The Developer tab will remain visible until you turn it off or reinstall Microsoft Office.
Click File (Windows) or Excel (Mac). You'll see the "File" tab in the editing ribbon above your workspace for Windows and the "Excel" tab in the menu at the top of your screen for a Mac.
Hover over Options/Preferences and select Customize Ribbon/Ribbon & Toolbar. A new window will open with options for the editing ribbon.
Click to select the box next to "Developer." It's under "Main Tabs."
Click Save and close the window (if necessary). If the window doesn't close by itself, you need to click the x manually.
Removing Buttons
Open your project in Excel. You can open your project within Excel by going to File > Open or you can right-click the Excel file and select Open with > Excel.
Turn on Design Mode. Go to the Developer tab and click Design Mode in the "Controls" group.
Select the button/controls you want to delete. Click to select them, and they will highlight to indicate that you have them selected. You can also select all the buttons in your Excel project by pressing CTRL/Cmd + A.
Press ← Backspace (Windows) or Delete (Mac). The selected buttons will disappear from your worksheet.
Comments
0 comment