Keep formulas in an Excel template when I delete data
 

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

Keep formulas in an Excel template when I delete data
 

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

Keep formulas in an Excel template when I delete data
 

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

Keep formulas in an Excel template when I delete data
 

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

Keep formulas in an Excel template when I delete data
 

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

Keep formulas in an Excel template when I delete data
 

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 -

Keep formulas in an Excel template when I delete data
 

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


"Pete_UK" wrote:

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 -