Hi I have excel 97 and want to protect a sheet, but unprotect some cells to type in. I have done this before, and know i need to protect the whole sheet, and 'unprotect' the individual cells. However I can't remember how, can anyone help
DON'T protect the worksheet first. Select the cells you want to leave unlocked. Go to Format - cells and then choose the protection tab. Remove the tick in the Locked box. THEN protect the worksheet. All cells you have not selected are then locked
This thread is now locked and can not be replied to.