Cell Fomula

[Ninfa]

How do I clear a spreadsheet (or columns) but retain the formulas to be used
over and over for different projects?

[Paul B]

Ninfa, one way, edit, goto, special, check constants, OK, then delete
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ninfa" <[email protected]> wrote in message
news:[email protected]...
> How do I clear a spreadsheet (or columns) but retain the formulas to be
> used
> over and over for different projects?

[Ninfa]

Thanks Paul, but what I do if I'm using Excel 2000? It doesn't have special
under edit.
Ninfa

"Paul B" wrote:

> Ninfa, one way, edit, goto, special, check constants, OK, then delete
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Ninfa" <[email protected]> wrote in message
> news:[email protected]...
> > How do I clear a spreadsheet (or columns) but retain the formulas to be
> > used
> > over and over for different projects?
>
>
>

[Peo Sjoblom]

Paul said edit>goto, then click special etc You can also press shortcut F5,
then special and constants etc

Regards,

Peo Sjoblom


"Ninfa" <[email protected]> wrote in message
news:[email protected]...
> Thanks Paul, but what I do if I'm using Excel 2000? It doesn't have
special
> under edit.
> Ninfa
>
> "Paul B" wrote:
>
> > Ninfa, one way, edit, goto, special, check constants, OK, then delete
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "Ninfa" <[email protected]> wrote in message
> > news:[email protected]...
> > > How do I clear a spreadsheet (or columns) but retain the formulas to
be
> > > used
> > > over and over for different projects?
> >
> >
> >