Try something like this:

Select the entire sheet
Unprotect ALL of the cells

Then <edit<go to[Special] formulas
Protect the selected cells.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Louise" wrote:

Hi all

How do I select ALL the cells on a worksheet that don't contain a formula?
I can go to Edit, Go To, Specials and select Constants but this only picks up
those cells where I have entered text, not where they are also blank.

I am basically trying to select every cell on the workbook that doesn't
contain a formula, unlock them, and then protect the rest of the sheet so
only the formulas cannot be edited by other users.

Thanks.
Louise