Fill Checkbox Log Gratuito

hello and welcome to this video tutorial from computer ggar.com 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 far I want to insert check boxes 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 I also want the cells to change color so it's very Visual and 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 checkbox form control you'll see in here there's two different check boxes active X and form for the purpose of this tutorial I'm going for the form control and I'm I'm going to Simply click and drag to kind of draw that onto my sheet and position it as desired so that's going nicely in the center of that cell now you'll notice that it puts a default label of check well you can't see the whole thing there but it says check box uh blah blah blah in there and that is not what I want I want them to be empty because I kind of have a label next to it which I'm writing in the CES instead so I'm go to right Mouse click on that check box and choose edit text so that I can simply delete Del that text and you can see what I'm saying now you can see the word box 28 get rid of all that click away and now it's clear and empty and looks a lot neater now I need one of those checkboxes for every single name in my list or every item in my list now I'm going to click on the cell and just simply copy and paste the one I have do not click on the check box click on the cell that contains the check box it's very important at this point that that checkbox is completely enclosed within that cell I just simply do a normal copy and paste I'm using the keyboard shortcuts contrl C and contrl V right now so you can't really see much going on but however you do it I'm simply copying and pasting I'll press Escape so that I get a duplicate checkbox at equal sizing equal positioning within each cell I pasted it within so now usually we have a neat looking checklist how you albeit quite small but now we're losing functionality at the moment I can check these boxes but nothing really happens now we need to record the value of the check boox somewhere it's known as the sell link with check boxes I can do that by right clicking a check box and formatting the control uh and using the sell link option provided in here but a slightly quicker way for us is to select the check box now we need to do that by holding down control on your keyboard and then clicking on...