copy formulae in excel

B

beginner

How do I copy a formulae to next rows without having Excel update the
formulae in relation to the new cell?
 
J

JLatham

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

Copy addition formula of non-consecutive horizontal cells 2
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Cannot access to Office Insider 0
How to Update SUM formula after inserting rows 2
Excel - Wich Function should I use? 1
Embed the same Excel multiple times 0
Need Help with a VBA subroutine 0

Top