Solved

my excel cannot update the formula when i drag it

Posted on 2014-01-17
4
221 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 32

Expert Comment

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

Thanks
Rob H
0
 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 167 total points
ID: 39788482
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
ID: 39788497
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:
Danny Child earned 167 total points
ID: 39789712
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

911 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

18 Experts available now in Live!

Get 1:1 Help Now