PDF download Download Article PDF download 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.

Part 1
Part 1 of 2:

Enabling the Developer Tab

PDF download Download Article
  1. 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.
  2. 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
  3. A new window will open with options for the editing ribbon. [1]
  4. " It's under "Main Tabs." [2]
  5. If the window doesn't close by itself, you need to click the x manually.
  6. Advertisement
Part 2
Part 2 of 2:

Removing Buttons

PDF download Download Article
  1. 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 .
  2. Go to the Developer tab and click Design Mode in the "Controls" group. [3]
  3. 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 .
  4. The selected buttons will disappear from your worksheet. [4]
  5. Advertisement

Expert Q&A

Ask a Question
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Thanks for submitting a tip for review!

      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 33,354 times.

      Is this article up to date?

      Advertisement