Copy a Formula

[stuck]

I was wondering how I could copy a formula into other
cells without the cell ranges in the formula changing.?

I want to copy a basic formula then change it throughout
where necessary.
thanks so much

 

[Andy B]

Hi

You need to make the cell references absolute eg:
Instead of =A1+B1 use =$A$1+$B$1
For more info, look for Absolute and relative references in XL help

 

[RagDyeR]

If your formula is a mixture of absolute and relative references,
Try this:

Select the cell with the formula.
Select the *entire* formula in the formula bar.
Right click in the selection and choose "Copy".
NOW ... hit <Enter>.

You can now right click in any cell, and choose "Paste", and the *exact*
formula that you copied will be duplicated in these cells.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I was wondering how I could copy a formula into other
cells without the cell ranges in the formula changing.?

I want to copy a basic formula then change it throughout
where necessary.
thanks so much