Copy formulas without data.

  • Thread starter Thread starter Praising Jesus
  • Start date Start date
P

Praising Jesus

I have a complex spreadsheet that has many formulas and much data. It was
not well designed, but I inherited it. Now I have to start the new fiscal
year and I want to delete all the data, but leave the formulas, headers and
such intact. Is there a way to do this? Deleting cell by cell is going to be
a big project.

---Mike
 
Perhaps to drastic for things with existing descriptions, you might
want to first make a selection of the columns to be affected and then
use the Edit --> Goto --> Special --> Constants, Del key
I would think you have descriptions in at least column A.
In any case you do have to make a selection first even if it is Ctrl+A,
anything is preferable to letting Excel make a choice for you.

If you need to insert or delete rows when you are updating you might take a look at
http://www.mvps.org/dmcritchie/excel/insrtrow.htm
 
I've been using Excel since 1.0 and I've been using PC's since 1983 - and
it's amazing what I don't know. Thanks!

---Mike
 
Back
Top