Turn off auto correct of formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I'm having formula issues 3
Summing 2 columns cells into a 3rd colums cells 1
Column sum incorrect upon subtracting 6
Need help with a SUM formula... 7
Any ideas for this formula??? 3
my formulas return a zero 3
Apparent Formula Problem 1
right formula? 2

Back
Top