Locking/Freezing cells

[loubla]

Hi, I would like to have a spread sheet that displays a set of cells when only certain cells are to be editied.

How can I "Lock" cells (for the need of a better word) so that they can be viewed, function calculate but they cannot be edited.

Ps I want to "lock" most of the sheet with only a select few fields that can be edited/changed

 

[ameydabholkar]

loubla,
You need Normal method or VBA Method.
And also you have to Lock it with a password.

Regards
Amey.

 

[loubla]

"You need Normal method or <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> Method.
And also you have to Lock it with a password."

I don't know what normal method or VBA Method are, plus I don't need a password

Thanks anyway

 

[FormR]

Take a look here:

Lock cells in a worksheet - Excel - Office.com

 

[shcon]

Please go to this post for tip to use lock sheet

 

[loubla]

Thanks FormR and shcon for your reply.

I look forward to checking out those resources