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

excel

ResolvedVersion 2003

Anthony has attended:
Excel Intermediate course

Excel

How do you protect a worksheet

RE: excel

Hi Anthony, Thank you for your post, welcome to the forum, in answer to your question, protecting the worksheet;
I am going to answer two questions here, the first is protecting your Workbook against access by unwanted visitors, and the second is protecting a Worksheet against change.
First: to password protect your Workbook, there are 2 ways, (I know always more than one way to do something in MS Office)
1. When you save your Workbook, in the Dialog box for Save As you will see the tab Tools, click this and choose the option General Options, in the little dialog box that opens insert Passwords as required, (open or modify).
2. To add Password protection to your Workbook whilst you have it open, go to the Menu command, Tools>Options, and choose the Security Tab, the same two choices as above will be available to you.
Second: to protect your Worksheet against change, you would have decided on cells which you "Will Allow" changes to be made in, select these cells/ranges of cells, and go to the Menu command Format>Cells, click the Protection tab and de-select the tick box for Locked, click OK which will return you to your worksheet.
This has now set those cells to be unlocked when you protect the worksheet, allowing users to enter only into these cells and not others.
But before this has come into force you must add one last bit to bring it all together, go to the Menu command Tools>Protection and from the pop out select Protect Sheet, again you will be asked if you wish to apply Protection to locked cells, (remember you have unlocked some) you can apply a password or not, click OK and you will notice that only the areas you wish to allow access to are able to be used without a message box popping up.
Perhaps a good idea now would be to create a Template of this Workbook to be able to use it over and over again.
I hope that has helped, best regards Pete.

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

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.