Is there a way that I can clear the info/data without removing the formula?

Thanks
Kevin

Select the range to clear -- include any formulas you want, but don't include
any cells with data you want to keep (like headers, instructions, ...).

Then hit F5
Then click the Special button
Select constants
Click ok

Hit the delete key on the your keyboard.

Then the cells in the original selection that were constants will be cleared,
but the cells with formulas will be untouched.

On 09/19/2010 05:13, Roger Dodger wrote:
> Is there a way that I can clear the info/data without removing the formula?
>
> Thanks
> Kevin
>
>

--
Dave Peterson