Download Article
Download Article
This wikiHow will teach you how to delete a button or control in Excel on a computer. You'll need to have enabled the Developer tab on the editing ribbon to do this.
Steps
-
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.Advertisement
-
Hover over Options/Preferences and select Customize Ribbon/Ribbon & Toolbar . A new window will open with options for the editing ribbon. [1] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click to select the box next to "Developer. " It's under "Main Tabs." [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
-
Click Save and close the window (if necessary). If the window doesn't close by itself, you need to click the x manually.
Advertisement
-
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. [3] X Research source
-
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. [4] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Advertisement
Expert Q&A
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
Advertisement
Tips
Submit a Tip
All tip submissions are carefully reviewed before being published
Name
Please provide your name and last initial
Thanks for submitting a tip for review!
References
- ↑ https://support.microsoft.com/en-us/office/use-the-developer-tab-to-create-or-delete-a-macro-in-excel-for-mac-5bd3dfb9-39d7-496a-a812-1b5e8e81d96a
- ↑ https://support.microsoft.com/en-us/office/show-the-developer-tab-e1192344-5e56-4d45-931b-e5fd9bea2d45
- ↑ https://www.extendoffice.com/documents/excel/5105-excel-remove-all-buttons.html
- ↑ https://support.microsoft.com/en-us/office/delete-controls-on-a-worksheet-9ddcf8f5-75b8-4ad6-98cf-611da389bb58
About This Article
Article Summary
X
1. Enable the Developer tab in Excel.
2. Turn on Design Mode.
3. Select the button/controls you want to delete.
4. Press Backspace/Delete
.
Did this summary help you?
Thanks to all authors for creating a page that has been read 38,051 times.
Advertisement
