Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 38,828 times.
Learn more...
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] -
Click to select the box next to "Developer." It's under "Main Tabs."[2] -
Click Save and close the window (if necessary). If the window doesn't close by itself, you need to click the x manually.
-
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] -
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]
Expert Q&A
Tips
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
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.
