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

protection

ResolvedVersion 2007

Efua has attended:
Excel Intermediate course

Protection

How do I protect a worksheet

RE: Protection

Hello Efua

Thank you for your question and welcome to the forum.

To apply protection to a worksheet, go to the Review tab, and click the Protect Sheet button.

Create a password (if you wish), and tick any actions that you want people to be able to perform even when protection is applied.

If you have entered a password, you will be prompted to enter it again.

Click OK to apply protection.

Kind regards
Amanda

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

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.09 secs.