![]() Let’s now delete multiple checkboxes at once with the mouse. Now just press DELETE on the keyboard and the checkbox is removed.ĭelete Multiple Checkboxes Using Your Mouse Checkboxes in Excel are viewed as objects, so all objects – in this case, the checkbox in B2 – are selected.In the pop-up screen, check Objects and click OK.In the Ribbon, go to Home > Find & Select > Go To Special.As you can see, the value (TRUE) remains in cell D2, but only as a value, since the link to the checkbox is deleted at the same time.ĭelete a Single Checkbox Using Go To SpecialĪnother way to delete a checkbox is to use the Go To Special option in Find & Select. If you want to delete the checkbox, press and hold CTRL, click on the checkbox, and press DELETE on the keyboard.Īs a result, the checkbox is removed from the worksheet. In cell D2, you have the value of the checkbox (in this case TRUE, as it’s checked). Suppose you have one checkbox in a worksheet, named Check Box 1 with the text January. ![]() ![]() ![]() Delete a Single Checkbox Using Your Mouse Note that Go To Special is the better option when deleting multiple checkboxes. ![]() If you have a checkbox (or a couple of them) in Excel and want to delete it, you can do it either by mouse selection or with the Go To Special option. This tutorial demonstrates how to delete checkboxes in Excel and Google Sheets.ĭelete Multiple Checkboxes Using Go To Special ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |