Standard Excel only lets you protect whole sheets. Kutools features an utility that lets you scramble the actual content of selected cells so they are unreadable without the password.
Manually opening every single file to add a password is a productivity killer. Kutools allows you to at once: kutools for excel password