Keep formulas in an Excel template when I delete data

  • Thread starter Thread starter Brile
  • Start date Start date
B

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?
 
Hi,

this does not make them remain, do I need to do anything else, choose
Formulas etc?
 
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.
 
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?
 
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
 
Hi, it does not matter wheter I get a error message as long as the formula
stays "behind" the error message.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keep formula delete contents 3
Excel Help to copy information from one row at a time to another sheet 1
How Do I Avoid #REF! In Formulas? 4
Advanvnce formula and function 1
Can I delete the data and keep formulas for a whole worksheet? 4
Remove the formulae, but keep the data 3
Lock formulas only not data 5
delete data -not formula 3

Back
Top