Hello,
I'm making an exell sheet and i want to send it arround to my friends but they are only allowed to fill in certain cells.
How do I do it?
Thanks in advance
Hello,
I'm making an exell sheet and i want to send it arround to my friends but they are only allowed to fill in certain cells.
How do I do it?
Thanks in advance
Hi
One way is this.
Highlight the cells that you will allow them to fill. Right click, format cell, protection, uncheck the lock option.
Then use PRotection of the sheet(Tools>>Prodection>>ProtectSheet.)
Another option is using Custom Validation.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you very much!
You are welcome!
Pls mark your Thread,as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks