- Apr 6, 2006
I have a sheet with 2 columns locked containing formulas. Sometimes I have extra rows that do not contain data but since the columns are locked I cannot hide the rows. I want to be able to hid the empty rows while the sheet is locked but it does not allow me to because it is locked. Is there any way around this besides unlocking, hiding and then relocking. I am having a terrible time with my employees unlocking the sheet and messing up a formula then re-locking. I want to be able to keep it locked for good but still be able to have employees hide rows if need be. Thanks in advance.