How to make only certain cells read only

[81shelly]

Hey guys..

Do u know if it is possible to to make excel read only but have certain columns where you can still input data? and the other columns are locked?

Thanks in advance

 

[Lewiy]

Format>Cells>Protection, check or uncheck "Locked" as desired.

All the cells are "Locked" by default so that when the worksheet is protected, they cannot be edited. Select the cells you want to leave unlocked and then uncheck the "Locked" option.

 

[81shelly]

ok thanks for that..