Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How do I unprotect sheet???

How do I unprotect sheet???

ResolvedVersion 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:

Convert Text into Number

Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

How do I unprotect sheet???

How do I unprotect sheet???

RE: How do I unprotect sheet???

Excel articles

Excel tip:

Convert Text into Number