Link to home
Create AccountLog 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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of Mr_Shaw

ASKER

thanks