View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default 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