Protecting data/Worksheets

Hi Davina,

Thank you for the forum question.

You have a lot of option to protect your workbook, worksheets data.

If you have a look at the link below, you will find some of the options.

https://support.office.com/en-us/article/Password-protect-worksheet-or-workbook-elements-dbf706e0-ba22-4a08-84d8-552db16eef11


You can lock a worksheet. You can password protect a part of a worksheet. You can protect the structure of your workbook so no one can delete, add,copy or move your worksheets. You can protect so no one can change the name of your sheets.

You can write protect your workbook. You can add a password to open your workbook. You can add password to specific ranges in your worksheets.

What do you want to do?

You have also options if you share the workbook and if you are working with macros you have more options for protection.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector