Forum Discussion
Tracking check boxes
Please can anyone assist? I am a teacher and as part of my development this year, I am looking at tracking the instances of late or not done homework - both for myself and my department. I had the ...
G_Wood_1976 Checkboxes in Excel are a nightmare to maintain. I would suggest the following:
- Select all cells that need a checkbox
- Choose Data Validation from the Data menu:
- Make sure the dialog looks like this:
- Click OK
Now all they have to do is enter a y or an n into those cells, or they can use the in-cell drop-down: