Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check Boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) | |||
how do you add up check boxes | Excel Discussion (Misc queries) |