How do I lock a column in EXCEL to prevent changes-can add input
I have been struggling with this problem.
I have created a form in Excel that will be used by many people. I have to be able to lock 3 columns in the form so that no one but me and 1 other person can change the verbiage in these 3 columns. The rest of the columns in the document needs to be accessible to enter numbers next to the locked columns. Any assistance would be appreciated!!!!!! Thanks! Aimee |
How do I lock a column in EXCEL to prevent changes-can add input
1st) Make sure only the cells you don't want to change are marked as locked,
to do this first unlock all cells (select all and Format-Cells-'Protection' Tab-Un-Check 'Locked')... doing this step first will ensure you lock only the cells you want. 2nd) Follow the above procedure, this time only selecting the cells you want locked, and making sure "Locked" is checked. 3rd) Tools-Protection-'Protect Sheet...'-Enter a password to un-lock, and press OK Does that help? -- Regards, Dave "amarie" wrote: I have been struggling with this problem. I have created a form in Excel that will be used by many people. I have to be able to lock 3 columns in the form so that no one but me and 1 other person can change the verbiage in these 3 columns. The rest of the columns in the document needs to be accessible to enter numbers next to the locked columns. Any assistance would be appreciated!!!!!! Thanks! Aimee |
All times are GMT +1. The time now is 08:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com