Hi All,

I hope someone can help me with my excel problem.

Here is the situation:

I have a large status spread sheet. It is a list of multiple projects. Each project has its own project manager, various team members who are working on it and different phases of the project. we keep track of where we stand with check boxes for each phase. so everyone can see the progress of the project.

The issue:

when I filter the list for projects for a specific project manager (manager A), the rows for manager B and C disappear, but the checkboxes for those properties are still visible and merge with the checkboxes from manager A. It appears as there are multiple checkboxes in one cell. When I "clean" it up so that only one checkbox is left in the cell and "unfilter" I noticed that I deleted checkboxes from the managers B and C.

I made sure that the frame of the checkboxes is smaller than the cell and that the frame is not overlapping any other cells.

The properties for the check boxes are set to "move but not scale with cell".
The selection "move and scale with cell" is not available for me. (don't know why and if this is the solution to my problem how can I enable this selection?)

I hope I was clear in my explanation and I hope someone has an ideas how to hide the checkboxes with the rows which I don't want to see when I apply the filter command.

It's driving me crazy and the whole table is kind of useless if I can't use the filter...

Thanks in advance.

Antje