Exel 2002 XP3 Protecting Cells

  dogbreath1 10:36 25 Aug 09

Is it possible to protect cells by what they contain rather than to highlight those cells which require protection?

It would be useful to be able to protect cells which, for example, contain text, are blank and/or contain a formula.

  VoG II 10:53 25 Aug 09

Taking formulas as an example:

Select the entire sheet by clicking the grey square to the left of A and above 1.

Format > Cells > Protection tab, untick Locked, click OK.

Press F5, click Special, tick Formulas, click OK.

Format > Cells > Protection tab, tick Locked, click OK.

Tools > Protection > Protect Sheet.

  dogbreath1 12:49 25 Aug 09

Many thanks, VoG™!

That really is a big help. :)

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now