Allow users to only enter in one cell

[david1987]

Hi,

I'd like to only allow users to enter in one cell in the spreadsheet, how can I do this?

Thanks

David

[gpato]

Easier for me to paste a link then type it myself.

[Bhuvi]

Hi,
You can do this by protecting the worksheet cells. Do the following :

Select the cell which you want to enalble for entries.
Right click on the cell and select option "Format cells" , then Go to tab "Protection" and uncheck the "Locked" option.
Then on the excel 2007 ribbon go to "Review" and then to "Changes" section. Select the "Protect Sheet" option and press ok.

[dilipandey]

Nice one Bhuvi


Cheers

Regards,
DILIPandey
<click on below * if this helps>

[Bhuvi]

Thanks Pandeyji..

Regards,
Bhuvanesh

<click on below * if this helps>

[mifzal.mufthi]

I have created a shared workbook to update certain entries by my colleagues. I have noticed that some of the entries were deleted after some time. I want to know if I can share the work with the following feature:-

As soon as somebody enters data to a cell, it should be automatically locked and should not allow anyone to delete or edit the cell.

How do I do it? Please help me. Thanks in advance.

[dilipandey]

Hi Mifzal,

Suggest you to create your own thread.. thanks.

Regards,
DILIPandey
<click on below * if this helps>

[mifzal.mufthi]

I have already but no response brother.

[arlu1201]

Mifzal,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

If you have not received a reply to your thread, bump it by typing "Still need help" or something but do not hijack another users' thread.