Forum Discussion
REMOVE A CHECKBOX FROM EXCEL WORKSHEET
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.
HansVogelaar I've brought information from a health account into Excel. With it came a check box that I can't get rid of. If I delete the row, it stays on the new one. I've tried the Developer, Design, Delete, and that doesn't work.
At the moment, I have it so that when I click on it, =EMBED("Forms.HTML:Checkbox.1","") shows up in the edit line. The check box will also outline with a box of 'o's, but won't delete.
- ritsunSep 07, 2023Copper Contributor
you can try this . first click on files tab and the at bottom click options now a new window opens there click customize ribbon in customize ribbon on right side click developer and then click ok. Now you can see a developer option on your ribbon on top. Now click that developer and then click design mode. Now you will be able to select the check box after selecting the checkbox go to home and click find and select tab, on that tab click go to special tab now on go to special select objects now the check box will be selected now you can delete the checkbox HalENT
- HansVogelaarMar 28, 2023MVP
Have you tried the suggestion by Dennis_Lewis ?
- jim_j2365Mar 09, 2024Copper Contributor
HansVogelaar Check boxes gone thank you Hans Vogrlaar suggestion :Mar 28 2023 12:27PM to use Dennis Lewis Suggestion : Feb 3 2023 03:59 find /select objects special objects and and delete.