Read only cells

gbarclay2001 · May 14th, 2002, 08:32 AM

Another question.

I have some formulas in cells but I want to prevent anyone typing over them by mistake. Is there a way to do this?

Mudface · May 14th, 2002, 08:35 AM

Try this-

Select areas where you want to allow people to type in data. Click of Format Cells- Protection and uncheck the locked box. Then click on Tools- Protection- Protect Sheet, enter a password if you want.

crimlet · May 14th, 2002, 08:37 AM

several ways, this being the easiest. Right click on the sheet tab and select view code. Then in the properties box, usually at the bottom left of the screen input where the range you want people to be able to edit in the scroll area. e.g a1:b10

dk · May 14th, 2002, 08:37 AM

Hi,

Select the cells you want to allow editing in and choose Format, Cells. Then choose the Protection tab and uncheck the Locked checkbox. Then protect your worksheet.

You'll still be able to edit the Unlocked cells but any other cells will be protected.

HTH,
Dan

gbarclay2001 · May 14th, 2002, 08:39 AM

Perfect! I knew it'd be easy and I thought I used to know how but I guess not. Very handy!

Cheers.

Greg

dk · May 14th, 2002, 08:39 AM

Errrr! According to the 'posted' time this question was answered by 3 people within 5 seconds of it being posted. That's a SPICY MEATBALL!

Audiojoe · May 14th, 2002, 08:46 AM

Try replying to our friends overseas then, and watch in amazement as the screen tells you it took you half a day

gbarclay2001 · May 14th, 2002, 08:47 AM

Bloody Hell! I replied to mudface and was presented with about 8 essays worth of answers (slight exaggeration). If only all life's problems were solved so easily (like me about to ask my boss for Monday off, for example-fingers crossed)

Thank you all, I guess it was an easy question then?

Greg

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

May 14th, 2002, 08:32 AM	#1
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Another question. I have some formulas in cells but I want to prevent anyone typing over them by mistake. Is there a way to do this?

May 14th, 2002, 08:35 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try this- Select areas where you want to allow people to type in data. Click of Format Cells- Protection and uncheck the locked box. Then click on Tools- Protection- Protect Sheet, enter a password if you want.

May 14th, 2002, 08:37 AM	#3
crimlet Board Regular Join Date: May 2002 Location: Ipswich, Suffolk, England Posts: 135	several ways, this being the easiest. Right click on the sheet tab and select view code. Then in the properties box, usually at the bottom left of the screen input where the range you want people to be able to edit in the scroll area. e.g a1:b10

May 14th, 2002, 08:37 AM	#4
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, Select the cells you want to allow editing in and choose Format, Cells. Then choose the Protection tab and uncheck the Locked checkbox. Then protect your worksheet. You'll still be able to edit the Unlocked cells but any other cells will be protected. HTH, Dan

May 14th, 2002, 08:39 AM	#5
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Perfect! I knew it'd be easy and I thought I used to know how but I guess not. Very handy! Cheers. Greg

May 14th, 2002, 08:46 AM	#7
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Try replying to our friends overseas then, and watch in amazement as the screen tells you it took you half a day

May 14th, 2002, 08:47 AM	#8
gbarclay2001 New Member Join Date: Mar 2002 Location: London Posts: 46	Bloody Hell! I replied to mudface and was presented with about 8 essays worth of answers (slight exaggeration). If only all life's problems were solved so easily (like me about to ask my boss for Monday off, for example-fingers crossed) Thank you all, I guess it was an easy question then? Greg