How do you select ALL cells that don't contain a formula
 

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

How do you select ALL cells that don't contain a formula
 

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

How do you select ALL cells that don't contain a formula
 

Yes, that would do it! Thanks Ron.

"Ron Coderre" wrote:

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