Protect Selected Columns On Excel Spreadsheet

Dizzieblonde | 17:56 Thu 16th Oct 2014 | Technology

1 Answers

Hi - Does anyone great with Excel know how I can protect only certain columns within an Excel spreadsheet, while allowing any users to add data to the remaining columns and cells? I've had a play but seem to end up locking the entire worksheet!

Scam Warning....

Seagate Ext H/drive

Answers

Only 1 answer

Best Answer

No best answer has yet been selected by Dizzieblonde. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

Mickey80

Hi DizzieBlonde,

What version of Excel is it. I'll assume 2010.

You have to protect the worksheet first... "Review Tab, Protect Sheet". In there you can select lock or unlock cells.

Then you can select cells, right click, Format Cell, Protection.

That's how I've done it in the past

Hope that helps

Only 1 answer

Do you know the answer?