Solved

# my excel cannot update the formula when i drag it

Posted on 2014-01-17
208 Views
When I drag a formula, my excel brings the formula very well but copies the original value where a dragged from.

Anthony
0
Question by:Anthony Matovu
• 2

LVL 31

Expert Comment

Sounds like you have Manual Calculation set. Press F9 to recalculate.

Thanks
Rob H
0

LVL 31

Assisted Solution

Rob Henson earned 167 total points
To change the setting for future, assuming you want to do so:

Excel 2003 - Tools > Options > Calculation tab - 3 options at the top.

Excel 2007 and later - Formulas tab on Ribbon > Calculation options - 3 options.

Thanks
Rob H
0

LVL 7

Assisted Solution

Steve earned 166 total points
Put Dollar signs(\$) in front of the row or columns you don't want to change when you drag it.

For example:
If you had  "=SUM(A2:A33)" in B1 and dragged it one cell to the right.
It would become:
"=SUM(B2:B33)"
If you put dollar signs in front of the rows and columns like this:
"=SUM(\$A\$2:\$A\$33)"
Then it won't change when you drag it.
0

LVL 23

Accepted Solution

DanCh99 earned 167 total points
Or, go to the formula bar at the top, select the formula in there, and press
CTRL+C
to copy it, and then paste this to the cell where you want it.
0

## Featured Post

### Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.