• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 280
  • 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 HensonFinance AnalystCommented:
Sounds like you have Manual Calculation set. Press F9 to recalculate.

Thanks
Rob H
0
 
Rob HensonFinance AnalystCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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