Excel tip: Make sure your sheet is protected

Kashflow logo

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:

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

Please Login or Register to read the full article

The full article is available to registered AccountingWEB.co.uk 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.

About David H Ringstrom


Please login or register to join the discussion.

By stgreg
18th Aug 2012 08:12

Can I protect the sheet but unprotect certain cells?

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?

Thanks (0)
18th Aug 2012 08:23

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

Thanks (0)