Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I Delete data in a spread sheet and keep formulas | Excel Discussion (Misc queries) | |||
How do I import data onto formulas in an excel template? | Excel Discussion (Misc queries) | |||
delete data, keep formulas | Excel Discussion (Misc queries) | |||
Delete all data (formulas) below a desired row. | Excel Discussion (Misc queries) | |||
how do I lock formulas, but I can still delete data? | Excel Worksheet Functions |