unlock

How to Use Excel Checkboxes | Interactive Checklists & Reports

0:00
↔️ ↕️

Timecodes:

Today, I'm going to show you how you can use  checkboxes in Excel to create checklists that  

look like this one. Adding a checkbox is very easy;  by using the outcome of the checkbox, so whether  

the box is checked or not. It's also really easy once  you understand how to use this one setting that  

I'm going to show you in a bit. In case you'd  like to improve your Office skills, make sure  

you're subscribed. Now let's get to it. I want to  add checkboxes right here, so as I'm going through  

my learning list and I finish something, I want to  place a check mark in the check box and I want to  

cross this off my list. First off, let's add a check  box. To do that, you need to go to the Developer tab.  

Now, if you don't see the Developer tab, because  it's not there by default, you need to right-mouse-click  

on your Ribbon, go to Customize the Ribbon,  under Main Tabs here, you're going to see Developer.  

Yours is not going to have a check mark beside it,  so you need to place a check mark and then click  

on OK, and then you're going to see Developer right  here. Then, go to Insert and from Form Controls, see  

the check box right here, that's what we need. Click  on it and then, draw it out where you want to have  

it. I want to have multiple check boxes in each  cell, I'm going to put mine right here, then you can  

click inside it or you can also right-mouse-click  on the check box and edit the text. Then, you can  

type in what you want, so I'm just going to remove  this and put "Done." You can also remove the text  

completely, so you don't have any text in there. Now,  I'm able to place a check mark in here or uncheck  

this. If I want to copy this down and apply it to  these cells as well, I can click on the cell itself,  

okay, so make sure it's a cell selected, and then  just drag this down until where you want to have  

it. And now, we have our multiple checkboxes. If  you just need to add simple checkboxes and you  

don't need to do anything with the result of the  checkbox, aside from seeing it visually, then you're  

done. But if you want something to happen when you  place a check mark in the check box, then you need  


Related queries:


how to open excel file online
how to unlock excel spreadsheet online
how to unlock excel file for editing online
how to open excel corrupt file online
how to open corrupted excel file online free
how to open encrypted excel file online
how to open local excel file online
how to open excel file in online mode
unlock excel files
how to unlock excel online
how to unlock protected excel sheet

Other suggestions: