Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

share|improve this question
    
this "little black square" is called fill handle :) –  Cornelius Jul 21 '10 at 7:53

1 Answer 1

up vote 1 down vote accepted

[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

share|improve this answer
    
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

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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