Delete cell contents while retaining formulas

I want to delete cell contents from cells I select without deleting the 
formulas. How do I accomplish this?

Thanks in advance.. 


0
cyberayk (3)
12/2/2004 5:33:58 PM
excel 39879 articles. 2 followers. Follow

1 Replies
468 Views

Similar Articles

[PageSpeed] 7

Hi
- select your range
- hit F5, click 'Special' and check 'Constants'
- now hit the DEL key

--
Regards
Frank Kabel
Frankfurt, Germany

"Dave A." <cyberayk@excite.com> schrieb im Newsbeitrag
news:Oo4ybUJ2EHA.1144@TK2MSFTNGP09.phx.gbl...
> I want to delete cell contents from cells I select without deleting
the
> formulas. How do I accomplish this?
>
> Thanks in advance..
>
>

0
frank.kabel (11126)
12/2/2004 5:39:35 PM
Reply:

Similar Artilces: