excel query

  User-5E734DF1-767A-4264-A22F5073B2DE367B 19:34 19 May 2005
Locked

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


Cheers


Lee

  Kenneth-266656 19:55 19 May 2005

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.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?