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

excel

ResolvedVersion 2007

James has attended:
Excel Intermediate course

Excel 2007

How do I protect a worksheet?

RE: Excel 2007

Hi James


Thank you for your question regarding protecting worksheets.

To protect an entire worksheet:
- Go to the 'Review' tab
- In the 'Changes' group select 'Protect Sheet'
- This will open up a dialogue box prompting you to enter a password.
- Re-confirm the password and click OK

The worksheet should now be password protected.


I hope this resolves your question. If it has, please mark this question as resolved.


If you require further assistance, please reply to this post.



Have a great day.

Regards,


Nafeesa

Microsoft Office Specialist Trainer

Sun 1 Aug 2010: Automatically marked as resolved.

Excel tip:

Switch between workbooks ni EXCEL.

use Alt-TAB to switch between workbooks.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.