Excel password

open the excel sheet

press F12..

this will open the "save as" dialog box..

to the top right hand corner u wud get properties or genereal options.. set password from der...

set password both for modification as well as opening the doc..

 Thanx  kaustubh for this valuable thing

Also, there are two passwords:

1. Password to open

2. Password to modify.

You can use both the passwords as per your need. ie if you want people to only VIEW your file and not edit it, you can use it accordingly.

hi

open d excel sheet

go to TOOLS > PROTECTION

dere u can protect only one sheet or the whole workbook

u cn define extent of protection also

hope it will help u out.....

There is another easy way.

Go to Tools > Options and select the Security Tab. You will have a dialog box for setting password both for open and modify.

Then you can save the file.

Rgds