How to encrypt, password protect and lock files in Excel 2007?

You can easily encrypt, password protect files and thereby lock files created using Microsoft office Excel 2007.

How to password protect files in Excel 2007?

Open the excel 2007 file to encrypt, password protect and lock
Click on the office Orb on the top left
Select Prepare >> Encrypt document

An Encrypt document dialog box pops up with an option for you to set password
Enter a strong password and click Ok
A confirm password dialog box pops up with an option for you to re-enter password and confirm it
If you are done with your work on the excel 2007 file, save your excel file.

Scroll Bar Missing in MS Word

In Office 2003
Go to Tools>Options>View

Under Show Check the vertical and Horizontal bars

How to password protect or encrypt Excel spreadsheets

How to set spreadsheet security in Excel 2002/2003

There is not something like an "encryption button" in Excel. On the other hand, encrypting Excel spreadsheets is just a few clicks away.
route 1: Tools | Options | Tab Security

route 2: File | Save As | Tools | General Options | Tab Security

File encryption options in Excel via the 'Save As' Menu

Security settings in Excel 2002/2003

The Security tab shows different security settings:
Open password
This password is used for spreadsheet encryption. This security feature is discussed in the next paragraph.
Modify password
This password is used for convenience when sharing spreadsheets. This password does *not* encrypt the spreadsheet and therefore does not add security. This modify password opens the Excel spreadsheet in an editable modus but prevents the original file from being overwritten. The modify password is stored within the Excel spreadsheet. There are tools available that can extract and remove this modify password.
Read-only recommended
This is a recommendation to the person opening the spreadsheet. On opening, Excel asks the user to choose read-only unless the user thinks that changes to the spreadsheet are necessary. It's just a recommendation, no security.

"Operating System Not Found" or "Missing operating system" error message when you start your Windows XP-based computer

• The basic input/output system (BIOS) does not detect the hard disk.
• The hard disk is damaged.
• Sector 0 of the physical hard disk drive has an incorrect or malformed master boot record (MBR).

 http://support.microsoft.com/kb/321626