Turn off auto correct of formula

S

Shaz-HCCU

Hi there ... I have a spreadsheet that has values in one column, with a total at the bottom. However the last cell prior to the total, I do not want included in the total. So I have an =SUM formula that does not include that cell ... but everytime I type something in that particular cell, the =SUM formula auto-updates itself to include that cell. How do I turn off this auto-update? The answer to this is probably so simple, but I'm blind to it .
 
E

Earl Kiosterud

Shaz,

Tools - Options - Edit - "Extend list formats and formulas." Turn it off.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Shaz-HCCU said:
Hi there ... I have a spreadsheet that has values in one column, with a
Click to expand...
total at the bottom. However the last cell prior to the total, I do not
want included in the total. So I have an =SUM formula that does not include
that cell ... but everytime I type something in that particular cell, the
=SUM formula auto-updates itself to include that cell. How do I turn off
this auto-update? The answer to this is probably so simple, but I'm blind
to it .
 
Top