copy formulae in excel

  • Thread starter Thread starter beginner
  • Start date Start date
B

beginner

How do I copy a formulae to next rows without having Excel update the
formulae in relation to the new cell?
 
Easiest way is to make the cell references absolute. If your formula looks
like this:
=A5 + B6
change it to
=$A$5 + $B$6
and then you can copy it without changing the references. The $ makes the
reference absolute. Look at Excel's Help topic for Absolute and/or Relative
addressing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
Auto Fill formula when inserting a new line 4
copy formulas over merged cells 2
copying groups with formulas 5
Excel Help to copy information from one row at a time to another sheet 1
Dragging/Copying Formulas in Excel 2007 3
copy/paste row with one formula 6
Odd Formula copying Behavior 3

Back
Top