Excel 2010

Hello Olivier,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding how to prevent users from using certain parts of a worksheet.

In Excel by default all cells are already LOCKED and to prevent anyone from editing anything on the sheet you must first protect the sheet with a password. If you want someone to edit sections of the spreadsheet then you must first select those areas and UNLOCK those cells, then password protect the sheet.

It seems though that you require larger areas to be UNLOCKED than LOCKED. If this is the case then select the whole worksheet and UNLOCK all the cells first by going to the HOME ribbon then clicking the arrow on the bottom right-hand corner of the FONT group > select the Protection tab and uncheck the Locked check box and click OK.

Then select all areas that should be LOCKED and follow the same procedure as above except this time put a tick into the Locked check box and click OK.

Next go to the Review ribbon and from the Changes group click the Protect Sheet button. Enter a password and then check the various permission options that you will allow users to perform and click OK. You will then be prompted to confirm your password.

Test this out... it works.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer