Autofill for checkboxes
Thanks guys.
Unfortunately that's not exactly what I'm looking for.
Let's say I have linked the first checkbox in A1 to the value in A1 so if I
check and uncheck that checkbox the value toggles between true and false.
Now I would like to select the right-below corner of A1 and drag it to F1 in
a way that all cells relate to the checkbox that is in the respective cell
(checkbox in cell B2 relates to cell B2).
Another question: how can you select more than one checkbox and delete them?
john
"john" schreef in bericht
...
I want the cell to change when the checkbox is changed and I have got that
working for one checkbox and the respective cell. Maybe Autofill isn't the
right word but I want to select the left-right-corner of the first cell
with the checkbox and drag it 176 cells further so that 176 checkboxes are
made and related to the cell they reside in.
"stevebriz" schreef in bericht
oups.com...
do you want the cell to change when the checkbox is change or vice
versa?
john wrote:
In my spreadsheet I need 177 checkboxes all linked to the cell they
reside
in. Is there a way to make one checkbox link it to the right cell and
then
autofill the other 176 checkboxes? The way I'm doing it now is not
working
as I have to make the link to the respective checkbox 176 times checkbox
for
checkbox.
thanks,
john
|