Link to home
Start Free TrialLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

Excel 2007 Locked columns

I have locked column K. However i can still input data. Is this normal.

I used http://www.technipages.com/excel-2010-2007-lockunlock-cells.html to help me.
SOLUTION
Avatar of Anil
Anil
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Shaw
Mr_Shaw

ASKER

I have now protected the worksheet. I have ticked all the boxes except 'Select locked cells' however I the spreadsheet wont let me don anything.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Shaw

ASKER

thanks