Just a small security tip for applying Passwords to the Excel 2010 workbooks in just one step and making them secure.

The security can be applied in 2 layers:

1) Password required to open the workbook, so if the user doesn’t have a password they can’t even view the workbook.

2) Password required to edit the workbook, in which you will be asked to enter a password incase you want to edit the spreadsheet.

It is up to your discretion whether you want to apply both of the above mentioned security levels or just one of them. So both type of security can be implemented with separate passwords to open and to modify the workbook.

To apply this just click save as and a dialogue box will appear, click on tools and select General Options and it will show you the General Options screen in which you can enter the password(s) to open and/or modify. Once done save the workbook, now it is password protected and the security level is far improved as compared to previous versions.

Be Sociable, Share!

•