R
Rob J
I have a class registration form built in Excel which features a column of
check boxes that flag attendance. If I manipulate the sheet using AutoFilter
to show only enrolled, canceled, waitlisted, etc., the check boxes behave as
expected and stay in their respective rows. If I do a sort, however, the
boxes keep their relative positions and don't go along for the ride with the
surrounding data. I have already checked that the Format Control option to
"Move but don't size with cells" option is selected. Is there a way to make
sure these checkboxes cooperate for sorts?
check boxes that flag attendance. If I manipulate the sheet using AutoFilter
to show only enrolled, canceled, waitlisted, etc., the check boxes behave as
expected and stay in their respective rows. If I do a sort, however, the
boxes keep their relative positions and don't go along for the ride with the
surrounding data. I have already checked that the Format Control option to
"Move but don't size with cells" option is selected. Is there a way to make
sure these checkboxes cooperate for sorts?