Protecting Worksheets in Excel

Protecting worksheets in Excel allows you to stop anything being changed on a worksheet or specifying that particular cells can be changed whilst others cannot. This is very useful if you want to make sure that certain cells are not changed inadvertently such as formulas and functions. This could be that you want to make sure you do not make a mistake yourself or because you have other people using it and you do not want them to make a mistake or make changes.

It can be useful to protect the information that is being used in a lookup.

It is possible to add a password or you can choose not have a password, if you do use a password make sure you remember it.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Microsoft Office, Office 2010 and tagged , , , . Bookmark the permalink.

One Response to Protecting Worksheets in Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s