Form 8815 Checklist 2022-2023

Instructions and Help about Form 8815 Checklist

Hello and welcome to this video tutorial from computer gargle calm in this video we are going to look at how to create an interactive checklist in Excel so on screen I have a pretend Christmas shopping checklist at the moment I simply have five names listed of fictional people that I'm imagining I need to buy for I want to insert checkboxes next to their names and then be able to mark those off as I do my purchasing do my gifting and when I do that also what the sales to change color so it's very visual very easy to see that they've been bought for so first of all we need the check boxes and for that we need the Developer tab up on the ribbon now if you do not have your Developer tab you will need to right mouse click somewhere on the ribbon choose customize the ribbon and then check the box for developer on the right-hand side I don't need to do that I have mine I'm going to go straight for the insert tab and go for the check box form control you'll see in here there's two different check boxes ActiveX and form for the purpose of this tutorial I'm going for the form control and I'm going to simply click and drag to kind of draw that onto my sheet and position it as desired so let's go in nicely in the center that cell now you'll notice that it puts a default label of Chick Webb you can't see the whole thing there but it says checkbox blob line there and that is not what I want I want them to be empty because I kind of m4 label next to it which I'm writing in the cells instead...