Keep formulas in an Excel template when I delete data

[Brile]

How do I keep the formulas in an Excel template when I delete actual data in
the rows and columns?

For example, if i have a table containing a lot of formulas, and I would
like to make the document "clean" without the data, for someone else to use
but keep the formulas for that person to use, how do I do that?

 

[Roger Govier]

Hi

Press F5>Special>Constants>OK>Delete

 

[Brile]

Hi,

this does not make them remain, do I need to do anything else, choose
Formulas etc?

 

[Roger Govier]

Hi

It selects all the cells that do not contain formulae and deletes the values
held in them.
All cells containing formulae will remain untouched.

 

[Brile]

Hi and thanks for the answer,

One final question to the subject: So then I can not set all the cells (with
formulas) to 0 or blank but with a formula "behind" the blank?

 

[Pete_UK]

You may well get errors showing up if you delete all the data, for
example if you have =a1/b1 you will get #DIV/0. You will need to amend
all you formulae to take account of the data cells being empty, eg:

=IF(b1="",0,a1/b1)

Hope this helps.

Pete

 

[Brile]

Hi, it does not matter wheter I get a error message as long as the formula
stays "behind" the error message.