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
|