formula advice

  • Thread starter Thread starter Debra
  • Start date Start date
D

Debra

I have a spreadsheet that has formulas and as rows are
added in alpha order, the formulas are not picked up in
newly inserted rows and when I try and copy and paste the
formula it picks up the formula but also copies the data
that was in the cell instead of just formula. how do I
correct this
 
If you want to copy a formula down as new rows are added, the formula
should contain relative references (=A2), instead of absolute references
(=$A$2).

For example, in row 2, you might have a formula: =A2*B2
When you copy this to row 3, it would change to: =A3*B3

However, if row 2 contains the formula: =$A$2*$B$2
when copied down, the references would not change.
In row 3, the formula would still be: =$A$2*$B$2
 
Back
Top