How Do I Lock Only Specific Columns & Make it password protected?
Hi Guys,
I'm outsourcing my data to someone who will be editing some of the text in one of the 8 columns. The data is very sensitive and I cant risk anything getting moved around. Is there any way I can just allow him to edit a specific column and keep the others Password protected and locked?
Thanks!
hi Inframan, welcome to the forum. select the entire of the column you wish you allow editing. press CTRL + 1 or right-click to go to Format Cells. go to the tab "Protection". Uncheck the "Locked". press OK.*
Now, right-click the Sheet & Protect Sheet. type a password if you have to. only those you did in Step 1 will be unlocked
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
Step1: Press Ctrl + 1 > Goto Protection tab > Uncheck the 'Locked'
Step2: Select all the Columns/Rows you want to protect
Step3: Press Ctrl + 1 > Goto Protection tab > Check the 'Locked'
Step4: Navigate to Review > Protect sheet > Check all the options & enter a password.
Done!
Please click 'Add reputation', if my answer helped you.
Example 1.jpgExample 3.jpg
Thanks but if you look at example 1, the only column I want to be editable is the last column, see example 3 - which settings do i apply for only that one column to be unprotected and the rest to be protected?
Last edited by Inframan; 09-23-2013 at 01:43 AM.
****CANCEL***** I did not see that you had two posts. Problem is solved !!! Thank You Sir !!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks