Hello,

I am trying to create a spreadsheet with numerous check boxes.

There are several columns. I want the first checkbox at the top of each
column to "activate" the column when it is checked, and "deactivate" the
column if it is not checked. (In other words, if that column is not checked,
then the work in that column is not done.)

Then, if the checkbox at the top is ticked, I want to be able to select
tasks in each row, that are checked as the task is completed.

I think, I also need to link these checkboxes to cells, as I want to be able
to sort at the end of the day what tasks remain uncompleted (unchecked)

How is this all done?

Thanks!

hi
i wouldn't use check boxes if i were you.
the check boxes "float" on top of the cells. and they don't sort to well.
the linked cells will. plus you would have to set each linked cell
individually. lot of work.
what i would do...
format the row at the top to marlett then press the lower case a or lower
case b to put a check mark in the cell.
in the column that you were planning to put the check box, i would do the
same....format to marlett and use the lower case a or b to put a check mark
in the cell. the check mark would then sort as you expected. achieves the
same results with a lot less work. and with the marlett check mark, you can
make the check marks different colors, different size ect.

my thoughts
Regards
FSt1

"suek" wrote:

Hello,

I am trying to create a spreadsheet with numerous check boxes.

There are several columns. I want the first checkbox at the top of each
column to "activate" the column when it is checked, and "deactivate" the
column if it is not checked. (In other words, if that column is not checked,
then the work in that column is not done.)

Then, if the checkbox at the top is ticked, I want to be able to select
tasks in each row, that are checked as the task is completed.

I think, I also need to link these checkboxes to cells, as I want to be able
to sort at the end of the day what tasks remain uncompleted (unchecked)

How is this all done?

Thanks!