excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

replyReply Thu 24 Apr 2008, 16:00Delegate Anthony said...

Anthony has attended:
Excel Intermediate course

Excel

How do you protect a worksheet

For upcoming training course dates see: Pricing & availability

replyReply Fri 25 Apr 2008, 09:13Trainer Pete said...

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.

 

Please browse our web site to find out more about
financial excel course london and other Microsoft training courses.

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard