Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: remove cell content but retain formula
-- I want to create a workbook to use as a form for ten novice users. This
work book will have cells that contain formulas that cause those cells to show data from other cells. I need to be able to delete the data from the cells without deleting the formulas. Then the workbook can be reused in its original condition without having to rewrite all the formulas. Cliver6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: remove cell content but retain formula
Edit | GoTo | Special | check the Constants box | OK
Now all cell with data other than formulas will be selected Tap the Delete key and they are gone This could be recorded and made into a subroutine best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Cliver6" wrote in message ... -- I want to create a workbook to use as a form for ten novice users. This work book will have cells that contain formulas that cause those cells to show data from other cells. I need to be able to delete the data from the cells without deleting the formulas. Then the workbook can be reused in its original condition without having to rewrite all the formulas. Cliver6 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: remove cell content but retain formula
So you want to be able to overwirte the formulas and then get them back
again? No can do. You could create a template allowing users to open a fresh copy each time. -- HTH... Jim Thomlinson "Cliver6" wrote: -- I want to create a workbook to use as a form for ten novice users. This work book will have cells that contain formulas that cause those cells to show data from other cells. I need to be able to delete the data from the cells without deleting the formulas. Then the workbook can be reused in its original condition without having to rewrite all the formulas. Cliver6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In excel how do remove a cel's content, but keep the formula? | Excel Discussion (Misc queries) | |||
How to delete/change the formula of a cell and yet retain its cont | Excel Worksheet Functions | |||
How delete formula bar and retain the computed number in a cell? | Excel Worksheet Functions | |||
How do you use EXCEL formula in properties of file (cell content) | Excel Discussion (Misc queries) | |||
Can I retain a formula in the cell pasted to? | Excel Worksheet Functions |