Hey guys please
I have alot of formula on C6: C36
how can hide and protect them so that they dont get erased
but people can still enter data into A6:A36 and B6:B36
Please any help
Thank you
Hey guys please
I have alot of formula on C6: C36
how can hide and protect them so that they dont get erased
but people can still enter data into A6:A36 and B6:B36
Please any help
Thank you
You need to select the cells that you want people to enter data into (A6:B36) > format Cells> Protection tab> Uncheck locked. Then you can protect your worksheet (with or without a password) and people can only enter data into the unlocked cells.
Questions?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
hi kuzna26.
1. select the entire worksheet first by pressing CTRL + A or click on the box on the left of Column A & on top on row 1. press CTRL + 1 to go to Format Cells. go to the tab "Protection". Uncheck the "Locked". press OK.*
2. now select only those you want to lock (i.e. C6:C36). again, CTRL + 1 & go to the tab "Protection". Check back the "Locked".*Hide the whole column if you wish to.
3. Now, right-click the Sheet & Protect Sheet. put a password there if you want to. only those you did in Step 2 will be locked
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks