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

Regards,

Peo Sjoblom


"Ninfa" <Ninfa@discussions.microsoft.com> wrote in message
news:CC405D53-464F-4CAA-8E13-CE78A70ED244@microsoft.com...
> 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" <Ninfa@discussions.microsoft.com> wrote in message
> > news:B6AB45F9-0949-442C-8D99-A0F5F25AF407@microsoft.com...
> > > How do I clear a spreadsheet (or columns) but retain the formulas to
be
> > > used
> > > over and over for different projects?
> >
> >
> >