0

This has only started happening recently, where I have say a list of values:

     A  B  C
     _  _  _
1|   1  4  5  [=sum(A1,B1)]

2|   2  5

3|   3  6 

I have my formula in cell C1 [enclosed in square brakcs for visualisation], and I want to duplicate it down the C column. So I select the cell, click the little black square bottom right of the cell, and drag it down.

The result is this

     A  B  C
     _  _  _
1|   1  4  5  [=sum(A1,B1)]

2|   2  5  5  [=sum(A2,B2)]

3|   3  6  5  [=sum(A2,B2)]

The sums don't actually evaluate until I go into each one individually, and click the formula bar, and click Enter. I don't want to have to do this for hundreds of rows.

Is there a 'Re-evaluate all Formulas' button? Like in Word, you can re-evaluate all items in a Table of Contents...

1
  • this "little black square" is called fill handle :) – Cornelius Jul 21 '10 at 7:53
1

[F9] - recalculates your workbook (and every function)

You might also go to options and check "calculations" tab (or similar, I don't have 2010 in front of me) and look for automatic / manual calculation method.

F9

Calculates all worksheets in all open workbooks.

SHIFT+F9 calculates the active worksheet.

CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.

CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.

source: microsoft.com

1
  • I knew there was a function like this, but the <kbd>F1</kbd> Help didn't well.. help. – glasnt Jul 21 '10 at 22:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.