Can I delete data in my spreadsheet and keep the formulas intact???

[mofohead]

I have a spreadsheet for our sales department. It contains some complex formulas for figuring all of their sales totals and all of that good stuff. They want a new version of this spreadsheet to work off of for 2004. I thought I would just save a copy of the spreadsheet then delete the data. Well, when I delete the data, it deletes the formulas as well.....How can I prevent that from happening???

Thanks.

 

[carrr]

Try Edit > GoTo > Special > tick Constants > Ok > now hit Delete

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[docjohn52]

Select the whole spread sheet and copy to clipboard

open new spreadsheet and "paste special value", click on formulas only, save as "whatever

 

[Wicca]

Merry Meet
Just a thought after doing all of that

Save a copy of the blank shet as a Template for 2005 maybe?



Merry Part and the Brightest of Blessings

With respect
Wicca
-----
IF you think you can
Or if you think you can't
Then you are probably right
-Henry Ford