View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
veneziagurl veneziagurl is offline
external usenet poster
 
Posts: 1
Default 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.