How do I unprotect sheet???

Resolved · Low Priority · Version 2007

Thu 8 Apr 2010, 03:02 Delegate Gen said...

Gen has attended:
No courses

How do I unprotect sheet???

I can't use my conditional formatting tool. A friend said it is protected.

quetsion is:

How will I unprotect it???

Fri 9 Apr 2010, 17:59 Trainer Andrew said...

RE: How do I unprotect sheet???

Hi Gen

Thank you for your question.

Click the Review ribbon and in the Changes group click Unprotect Sheet. Depending on how the sheet was protected you may need to supply a password before the sheet is unlocked.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Fri 16 Apr 2010: Automatically marked as resolved.

Excel tip:

Hiding Formulae in the Formula Bar

It is possible to protect the contents of a cell reference(s) from amendment by applying cell protection. The contents of the cell reference can also be stopped from displaying in the formula bar.

Step 1: Select Format > Cells > Protection.

Step 2: Tick Hidden option. Ensure Locked is ticked

Step 3: Select Tools > Protection > Protect Sheet

(Ensure "Protect worksheet and contents of locked cells" is ticked)

View all Excel hints and tips

How do I unprotect sheet???

How do I unprotect sheet???

RE: How do I unprotect sheet???

Excel articles

Excel tip:

Hiding Formulae in the Formula Bar