Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel

Nov 22, 2004 1:03AM PST

hello
I'm stephanie. I have a data in excel and I want to know if I am able to lock it.
Columns A, B, C, D, E, F are used for the data. Well, Column A, and B are filled out with some record
and the other columns need to entry data and automatically will do a caculation. There are formulas in each cell of columns C, D, E, and F. So I need to lock each cell...in that way when I insert records(number) on the cells, the formula won't disappear At the sametime it will ask me for a password when I select a cell. Does anyone know if it is possible to do that?... Please help
Thanks

Discussion is locked