microsoft+excel+course - excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+course - Excel 2007

microsoft+excel+course - Excel 2007

resolvedResolved · Low Priority · Version Standard

Gemma has attended:
Excel Introduction course
PowerPoint Introduction course

Excel 2007

How do you password protect a spreadsheet?

RE: Excel 2007

Hi Gemma, Thanks for the post, in answer to your question, to protect the worksheet you would choose the menu option Tools, Protection and then from the pop out choose Protect Worksheet, the application of a password is optional, you will have to enter it twice, the second time for confirmation. To protect the Workbook you would choose Menu option, File Save As and in the dialog box choose the Menu Option Tools, within the the pop out, choose General Options, insert your chosen password twice, remember if you lose the password you will not be able to gain access to the workbook. Hope that helps, best regards Pete.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Generate randon numbers

Some types of analysis require you to use randomly generated numbers. You can also use randomly generated numbers to quickly populate an Excel spreadsheet. There's an easy function you can use to do this automatically. Here are a few of the ways you can use it:

Type =RAND() in a cell to generate a number between 0 and 1.
Type =RAND()*100 to generate a number between 1 and 100.

View all Excel hints and tips


Server loaded in 0.09 secs.