ExcelBanter - delete the test values, but do not delete the formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - delete the test values, but do not delete the formulas (https://www.excelbanter.com/excel-discussion-misc-queries/131706-delete-test-values-but-do-not-delete-formulas.html)

Kathy

delete the test values, but do not delete the formulas

Gord Dibben

delete the test values, but do not delete the formulas

CTRL + a(twice in 2003) to select all.

F5SpecialConstants.

Select the Constants to find....numbers? and OK

EditClearContents

Just a note for future postings...........add some some description of your
problem in the body of the post, not just in the subject line.

Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 10:26:54 -0800, kathy
wrote:

All times are GMT +1. The time now is 10:02 PM.