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.
Bookmarks