Copy a Formula

  • Thread starter Thread starter stuck
  • Start date Start date
S

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

:)
 
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
 
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

:)
 
Back
Top