Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

my excel cannot update the formula when i drag it

When I drag a formula, my excel brings the formula very well but copies the original value where a dragged from.

Anthony
0
Anthony Matovu
Asked:
Anthony Matovu
  • 2
3 Solutions
 
Rob HensonIT & Database AssistantCommented:
Sounds like you have Manual Calculation set. Press F9 to recalculate.

Thanks
Rob H
0
 
Rob HensonIT & Database AssistantCommented:
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
 
SteveCommented:
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
 
Danny ChildIT ManagerCommented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now