PROCTECTING A CELL WITH FORMULA

webking · Mar 12th, 2002, 05:02 PM

I need to know how i can protect a cell which contain some important information , constant value or formula which i don't want that any one should rewrite.
AS manay times it happen that the cell which has formula in it is over-rewritten by mistake and the huge formula is Lost.

Steve Hartman · Mar 12th, 2002, 05:20 PM

In Excel, go up to the top of the screen and click Help. search on protection. If you still can't figure it out, repost the question.

webking · Mar 12th, 2002, 06:36 PM

I have tried the Protection option also for a cell but it did not worked out.
That's why iam asking on this forum, so if any one knows it please tell me the steps which i can follow for this.

Steve Hartman · Mar 12th, 2002, 06:52 PM

What did you do to try protection and how did it not work?

NateO · Mar 12th, 2002, 07:01 PM

On the cell in question, make sure you right-click, choose format, click the protection tab and make sure LOCKED is checked.

Now protect the sheet (tools->protection->protect sheet.....)

Hope this helps. Cheers,
Nate

[ This Message was edited by: NateO on 2002-03-12 13:02 ]

tk19 · Mar 12th, 2002, 07:03 PM

A couple of additional points: all cells are locked by default, but this locking does not go into effect until you protect the sheet.
You may want to protect your sheet with a password, also.
Choose Protection under the Tools menu.

Mark O'Brien · Mar 12th, 2002, 07:18 PM

I believe in Excel2002 (or XP or whatever it's called) there is an option to protect individual cells. I had this discussion with someone last week.

Unforunately I do not own Excel 2002 or else I would give you more details. If you don't have it and this formula is worth a couple of hundred (pounds, dollars, euros) then Iwould suggest getting 2002.

karraj · Mar 12th, 2002, 07:32 PM

In excel 97, you can selectively Protect cells in a round about way.
first Unprotect the sheet,
Remove the lock for cells you DO NOT want protection, by selecting the cells, then choose Format-> cells-> Protection, uncheck locked.
and then protect the sheet.
Now, your cell will be protected!

Mar 12th, 2002, 07:18 PM	#7
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,510	I believe in Excel2002 (or XP or whatever it's called) there is an option to protect individual cells. I had this discussion with someone last week. Unforunately I do not own Excel 2002 or else I would give you more details. If you don't have it and this formula is worth a couple of hundred (pounds, dollars, euros) then Iwould suggest getting 2002. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 05:02 PM	#1
webking Join Date: Mar 2002 Posts: 21	I need to know how i can protect a cell which contain some important information , constant value or formula which i don't want that any one should rewrite. AS manay times it happen that the cell which has formula in it is over-rewritten by mistake and the huge formula is Lost.

Mar 12th, 2002, 05:20 PM	#2
Steve Hartman Join Date: Feb 2002 Location: Houston,Texas Posts: 418	In Excel, go up to the top of the screen and click Help. search on protection. If you still can't figure it out, repost the question.

Mar 12th, 2002, 06:36 PM	#3
webking Join Date: Mar 2002 Posts: 21	I have tried the Protection option also for a cell but it did not worked out. That's why iam asking on this forum, so if any one knows it please tell me the steps which i can follow for this.

Mar 12th, 2002, 06:52 PM	#4
Steve Hartman Join Date: Feb 2002 Location: Houston,Texas Posts: 418	What did you do to try protection and how did it not work?

Mar 12th, 2002, 07:01 PM	#5
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,639	On the cell in question, make sure you right-click, choose format, click the protection tab and make sure LOCKED is checked. Now protect the sheet (tools->protection->protect sheet.....) Hope this helps. Cheers, Nate [ This Message was edited by: NateO on 2002-03-12 13:02 ]

Mar 12th, 2002, 07:03 PM	#6
tk19 Join Date: Mar 2002 Posts: 33	A couple of additional points: all cells are locked by default, but this locking does not go into effect until you protect the sheet. You may want to protect your sheet with a password, also. Choose Protection under the Tools menu.

Mar 12th, 2002, 07:32 PM	#8
karraj Join Date: Mar 2002 Posts: 76	In excel 97, you can selectively Protect cells in a round about way. first Unprotect the sheet, Remove the lock for cells you DO NOT want protection, by selecting the cells, then choose Format-> cells-> Protection, uncheck locked. and then protect the sheet. Now, your cell will be protected!