How to Insert a Checkbox in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office
How to Insert a Checkbox in Excel
Create a checklist for everything you need
By Amanda Derrick Amanda Derrick Freelance Contributor University of Utah Florida Tech Amanda Derrick is a mechanical engineer, business strategist, and former Lifewire writer who has also written for USAF Civil Service, ATK, and Boeing. lifewire's editorial guidelines Updated on October 11, 2021 Reviewed by Jon Fisher Reviewed by Jon Fisher Wichita Technical Institute Jonathan Fisher is a CompTIA certified technologist with more than 6 years' experience writing for publications like TechNorms and Help Desk Geek. lifewire's editorial guidelines Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook What to Know
You need to have the Developer tab in the ribbon. From there, select Insert > checkbox icon and place the box where desired. If you need a lot of checkboxes, the quickest method is to create the first one and then copy/paste the rest as needed. This article explains how to add the Developer tab to the ribbon, how to add single or multiple checkboxes, and how to delete a checkbox. Instructions apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel for Microsoft 365, and Excel for the web. How to Insert a Checkbox in Excel
Here's how to add a checkbox in Excel. (It's very similar to the way checkboxes are inserted in Microsoft Word.) Excel Online does not support the checkbox function. Make sure you have the Developer tab in your ribbon. If you don't see it, you can add it by going to File > Options > Customize Ribbon and selecting the Developer checkbox. Click OK. If you have Excel 2007, click the Microsoft Office and select Excel Options > Popular > Show Developer tab in the Ribbon. In the Developer tab, select Insert, then select the Checkbox icon under Form Controls. In the spreadsheet, click where you want to place the checkbox. You can immediately begin typing to edit the default text after the checkbox appears, or you can right-click on the checkbox to edit other characteristics. Options for the checkbox formatting include fill color, text color, borders, and other options. You can do this by right-clicking and selecting Format Control. Any edits to the checkbox must be done using a right-click; a left-click will check or uncheck the box. How to Create Multiple Checkboxes in Excel
The Checkbox function in the Developer tab only allows you to add a single checkbox at a time. However, once you have a few on your page you can select multiple checkboxes and use copy/paste to add more items to your spreadsheet quickly. Doing this is a little tricky since left-clicking on a checkbox just checks/unchecks the box itself. To copy/paste a checkbox, use right-click and select Copy. Then, right-click where you want the new checkbox to go and select Paste. You can then right-click on the checkbox again if you want to edit the text or formatting. You may find it easier to enter your line items in regular cells on the Excel sheet and then add a checkbox without using the checkbox text. When you click to place your checkbox, just click and highlight the text, and press the Delete key. Using Copy/Paste to duplicate checkboxes is a lot more efficient this way, and it makes editing the text easier as well. How to Delete a Checkbox in Excel
Have a checkbox you don't want to check anymore? How to delete a checkbox isn't immediately obvious, since regular clicks just toggle the check on and off. To get rid of a checkbox, right-click on it and select Cut. That's it! Just don't paste it anywhere and the checkbox is now safely out of your spreadsheet. Was this page helpful? Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Make a Checklist in Google Docs How to Insert a Link Into an Email With Outlook How to Use Google Sheets How to Merge and Unmerge Cells in Excel How to Insert a PDF Into Word How to Create Exploding Pie Charts in Excel How to Insert a Document in Word How to Use Text Boxes in Microsoft Word How to Delete a Blank Page in Word How to Change the Number of Decimal Places in Excel How to Insert Comments in Word How to Insert an Image Into Your Outlook for Mac Signature How to Hide and Unhide Columns, Rows, and Cells in Excel How to Insert a Page Break in Word How to Insert a Link in an Email With Mac OS X Mail How to Set Print Area in Excel Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. Cookies Settings Accept All Cookies