REMOVE A CHECKBOX FROM EXCEL WORKSHEET

%3CLINGO-SUB%20id%3D%22lingo-sub-1950995%22%20slang%3D%22en-US%22%3EREMOVE%20A%20CHECKBOX%20FROM%20EXCEL%20WORKSHEET%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1950995%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20handed%20an%20Excel%20worksheet%20that%20has%20three%20checkboxes%20that%20I%20wish%20to%20remove%20but%20cannot%20seem%20to%20remove%20them.%26nbsp%3B%20Excel%20Help%20says%20to%20right%20click%20the%20Box%20and%20then%20hit%20Delete.%26nbsp%3B%20There%20is%20no%20Delete%20in%20the%20ensuing%20dropdown%20menu%20and%20Delete%20on%20the%20keyboard%20does%20not%20work.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1950995%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1951491%22%20slang%3D%22en-US%22%3ERe%3A%20REMOVE%20A%20CHECKBOX%20FROM%20EXCEL%20WORKSHEET%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1951491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F889211%22%20target%3D%22_blank%22%3E%40tjbCanton2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20check%20boxes%20have%20a%20right-click%20menu%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ERight-click%20a%20check%20box.%3C%2FLI%3E%0A%3CLI%3EPress%20Esc%20to%20dismiss%20the%20right-click%20menu.%3C%2FLI%3E%0A%3CLI%3EPress%20Delete.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EIf%20they%20don't%20have%20a%20right-click%20menu%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EActivate%20the%20Developer%20tab%20of%20the%20ribbon%20(if%20you%20don't%20have%20a%20Developer%20tab%2C%20you%20can%20make%20it%20visible%20in%20File%20%26gt%3B%20Options%20%26gt%3B%20Customize%20Ribbon).%3C%2FLI%3E%0A%3CLI%3EClick%20to%20turn%20on%20'Design%20Mode'.%3C%2FLI%3E%0A%3CLI%3EClick%20on%20a%20check%20box%2C%20then%20press%20Delete.%3C%2FLI%3E%0A%3CLI%3EDon't%20forget%20to%20turn%20off%20'Design%20Mode'%20when%20you're%20done.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I was handed an Excel worksheet that has three checkboxes that I wish to remove but cannot seem to remove them.  Excel Help says to right click the Box and then hit Delete.  There is no Delete in the ensuing dropdown menu and Delete on the keyboard does not work.  

 

Any suggestions?

1 Reply

@tjbCanton2020 

If the check boxes have a right-click menu:

  • Right-click a check box.
  • Press Esc to dismiss the right-click menu.
  • Press Delete.

If they don't have a right-click menu:

  • Activate the Developer tab of the ribbon (if you don't have a Developer tab, you can make it visible in File > Options > Customize Ribbon).
  • Click to turn on 'Design Mode'.
  • Click on a check box, then press Delete.
  • Don't forget to turn off 'Design Mode' when you're done.