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.
Mr_ShawAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AnilData ManagerCommented:
You need to protect the sheet otherwise the lock has no effect.

A>
0
Mr_ShawAuthor Commented:
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.
0
regmigrantCommented:
The 'lock' on a cell is to prevent accidental overwrite of formula when the sheet is being used.

the principle is to lock all the formula cells and unlock all the data entry ones. Excel guesses what you need as you build the sheet and generally does a decent job of it.

To make this work you then protect the sheet as Mr Shaw said. by default this will let you move around as normal but only enter data into unlocked cells - ie: those with no formula in.

sometimes its useful to allow the sheet user to do more than just move to empty cells and fill in data and each of the options under 'protect sheet' gives them a little more flexibility such as the ability to sort, filter and so on. The default - 'select locked cells', 'select unlocked cells' is enough for many applications but if you dont want them to see your formulas you can uncheck 'select locked cells' and their cursor movement will be limited to the data entry cells only.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mr_ShawAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.