Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


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.


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .