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 » Excel 2007

Excel 2007

resolvedResolved · High Priority · Version 2007

Marc has attended:
Excel Intermediate course
Excel Advanced course

Excel 2007

How do you protect a workbook so that when re-opened, one has to enter a password before ANY information is seen?

RE: Excel 2007 - Pasword Protecting your Workbooks

Dear Marc

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


 

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips


Server loaded in 0.08 secs.