Solved

my excel cannot update the formula when i drag it

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

Anthony
0
Comment
Question by:Anthony Matovu
  • 2
4 Comments
 
LVL 31

Expert Comment

by:Rob Henson
Comment Utility
Sounds like you have Manual Calculation set. Press F9 to recalculate.

Thanks
Rob H
0
 
LVL 31

Assisted Solution

by:Rob Henson
Rob Henson earned 167 total points
Comment Utility
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

by:Steve
Steve earned 166 total points
Comment Utility
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

by:
DanCh99 earned 167 total points
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now