Adding Checkboxes to an Excel Spreadsheet Add the Developer Tab. To create the textbox, you need to start by adding. Insert Checkbox Control. Now that you have the Developer tab available, click on it. Format Checkbox Control. Once you have the checkbox in place, you may want to format it.. Here are the steps to insert a checkbox in Excel: Go to Developer Tab –> Controls –> Insert –> Form Controls –> Check Box. Click anywhere in the worksheet, and it will insert a checkbox (as shown below). Now to need to link the checkbox to a cell in Excel. In the Format Control dialog box, in.
![Add Checkbox To Excel Spreadsheet Add Checkbox To Excel Spreadsheet](/uploads/1/2/5/8/125825699/546836137.gif)
![Add excel spreadsheet to powerpoint Add excel spreadsheet to powerpoint](/uploads/1/2/5/8/125825699/935077334.png)
Active2 years, 7 months ago
I am trying to make a checklist in Excel.Basically I am trying to make a cell:
Into a checkbox that can be checked or unchecked, and saved with the spreadsheet:
It's super-duper easy to do it in Apple Numbers, but very hard to do in Excel.And exporting from Numbers to .xlsx doesn't support checkboxes yet.
I looked into 'Cell Style' but it's not a cell style. I looked into Format but it's not a 'format' either. I looked into 'Insert', into 'Page Layouts', into 'Formulas', into 'Data', I think I've looked everywhere, but I can't find this where I think it would make sense for this option to be.
Can it be done? And if yes, how?
MicroMachineMicroMachine
3 Answers
In Excel 2016, instead of “Customize Ribbon”, you will need to go to the “View” pane in Excel Preferences, then check the box next to “Developer Tab”.
Sathyajith Bhat♦53.7k3030 gold badges159159 silver badges254254 bronze badges
macztermaczter
- Click the File/Excel tab.
- Click Options/Preferences.
- Click Customize Ribbon.
- Under Customize the Ribbon and under Main Tabs, select the Developer check box.
- Go to the Developer tab - insert - and there will be a checkbox icon.
After you got the first one, you can copy-paste it.
Divin3Divin31,45311 gold badge99 silver badges2626 bronze badges
I have Excel 2011 for Mac. I had to go to preferences, then click on Ribbon and click on the Developer. Once that is done. Click OK.
When you return to Excel, you will immediately find the Developer tab right after the Review Tab. Now you can do your check boxes, lists etc.
Jaime IsaacJaime Isaac