| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In excel how do remove a cel's content, but keep the formula?
I have to keep the formulas in a template, but want to remove the value from
the cel. For example, I don't want someone to see the calculation total the formula has given me, I just want them to see the formula. Or conversly, hide the formula and the answer. It is important that I can put in the new users data and the formula will auto calculate the new answer based on their inputs. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel how do remove a cel's content, but keep the formula?
Edit/ Go To/ Special/ Values
Delete -- David Biddulph "veneziagurl" wrote in message ... I have to keep the formulas in a template, but want to remove the value from the cel. For example, I don't want someone to see the calculation total the formula has given me, I just want them to see the formula. Or conversly, hide the formula and the answer. It is important that I can put in the new users data and the formula will auto calculate the new answer based on their inputs. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In excel how do remove a cel's content, but keep the formula?
Make that EditGo ToSpecialConstants and uncheck all but "Numbers"
Gord Dibben MS Excel MVP On Wed, 10 Dec 2008 09:30:01 -0800, veneziagurl wrote: I have to keep the formulas in a template, but want to remove the value from the cel. For example, I don't want someone to see the calculation total the formula has given me, I just want them to see the formula. Or conversly, hide the formula and the answer. It is important that I can put in the new users data and the formula will auto calculate the new answer based on their inputs. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Content linked to other cells formula Content | Excel Discussion (Misc queries) | |||
| Remove content when saving / loading spreadsheet | Excel Worksheet Functions | |||
| Remove content of last visited pages in "Insert Hyperlink" dialog | Excel Worksheet Functions | |||
| How do I remove a formula in Excel? | Excel Discussion (Misc queries) | |||
| How do you use EXCEL formula in properties of file (cell content) | Excel Discussion (Misc queries) | |||
Linear Mode
