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
|