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

On Oct 6, 12:17*pm, Brile wrote:
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?

--
Brile



"Roger Govier" wrote:
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.
--
Regards
Roger Govier

"Brile" wrote in message
...
Hi,

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

"Roger Govier" wrote:

Hi

Press F5SpecialConstantsOKDelete

--
Regards
Roger Govier

"Brile" wrote in message
...
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?
--
Brile- Hide quoted text -

- Show quoted text -