Excel tip: Make sure your sheet is protected

In his latest Excel tip article from AccountingWEB.com, David Ringstrom reviews the options for protecting the worksheet integrity in different versions of Excel.

Up until Excel 2003 there were two ways to determine if a worksheet was protected. The first involved attempting to modify a locked cell, which would trigger a warning message. Most seasoned Excel users will be familiar with the prompt that appears in when you try to modify a locked cell:

Excel protected cell warning

The second way to check a worksheet’s protection status involved choosing Tools-Protection, and looking for the Unprotect Sheet command.

To see the full instructions covering options for Excel 2010 and previous versions, register and log in to AccountingWEB.co.uk

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Can I protect the sheet but unprotect certain cells?

stgreg | | Permalink

When I build a spreadsheet for a client I want to allow them to enter information into certain cells.

I also want to stop them messing around with and messing up the structure of the spreadsheet by, for example, overwriting formulae.

I am sure that I used to be able to do this.

Can it be (easily) done in Excel 2010?

Yes

Outofpractice | | Permalink

It can be done in all versions right click the cells you want people to have access too go to format cells then the last tab and untick locked. They will be able to enter info if sheet protected