Thread: Formulas
View Single Post
  #1   Report Post  
excelrookie05
 
Posts: n/a
Default Formulas


Is there any way to type a formula into a cell, but not make it active?
I want to have the formula on the spreadsheet so that I can explain
what it does, but I don't want the equal sign to appear because it will
most certainly give me a value.

This formula will add all the sums of E4 through E10
=SUM(E4:E10)

Like I said though, I don't want the cell that this formulas is in to
have a value in there; only the formula itself must exist there.

Thanks all.


--
excelrookie05
------------------------------------------------------------------------
excelrookie05's Profile: http://www.excelforum.com/member.php...o&userid=27204
View this thread: http://www.excelforum.com/showthread...hreadid=467490