Excel tip: Make sure your sheet is protected

Columnist
Share this content
2

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

Replies

Please login or register to join the discussion.

avatar
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)
avatar
18th Aug 2012 08:23

Yes
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)