work book

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

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

Work book

resolvedResolved · Medium Priority · Version 2007

Ajay has attended:
Excel Intermediate course

Work book

how to i password a excel spreadsheet

RE: work book - Password Protection!!

Dear Ajay

Thank you for attending Excel 2007 Intermediate course.

I hope you enjoyed the course and benefited from it.

To password protect your Excel file in 2007 you have to go to your save As dialog box.

In the save As Dialog box you'll notice there will be Tools Button either on the bottom left hand coner or Top Right hand corner.

Please click on the drop down arrow and choose General options. Type the password you wish to set for the file. You can set different passwords; one for opening and one for modifying the file. You will be asked to re-enter the password.

IT IS VERY IMPORTANT THAT YOU REMEMEBR YOUR PASSWORD OTHERWISE IT CAN BECOME VERY VERYT DIFFICULT TO OPEN YOUR OWN FILES!!

I hope this helps!!

Please mark this post as resolved if it has helped you in answering the question!!

Many thanks

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

 

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:

Formst Excel to display leading zeroes

Select the cells that you want to have displaying leading zeroes.

From the 'Format' menu select 'Cells' (Or Right-click on the selected range and and select 'Format Cells').

In the 'Number' tab click on 'Custom' in the 'Category' window.

In the 'Type:' box enter zeroes that correspond to the size of the required number (eg 5 zeroes).

Click OK.

When you enter numbers into these cells, leading zeroes will be displayed.

eg 123 = 00123

View all Excel hints and tips


Server loaded in 0.08 secs.