auto-updating when i don't want it to

D

Dan

Type any 5 numbers in cells a1 through e1. Leave cell f1
blank for now, and type "=sum(a1:e1)" in cell g1. Now go
back and type a number in cell f1, and lo! Cell g1 now
contains the formula "=sum(a1:f1)". This is driving me
nuts! Is there a way to turn this "feature" off?

Dan
 
F

Felipe

Dan,

That only happens if you use the autosum feature, if you
directly type the formula in the cell it will not happen.

HTH,
Felipe
 

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

Function to show the greatest number of characters 4
Excel How to find the most common pairs and triplets numbers? 5
Spurious Formula Omits Adjacent Cells 1
Spurious Formula Omits Adjacent Cells 2
How to set cell value to emptry if three other columns are empty too 1
Subtotal Function is Inconsistent 4
Copy and Paste of Relative Cell References 1
Find the rightmost value 5

Top