Copying Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to copy, for example, a formula such as:

f4/f7+g4/g7+h4/h7

to the next cell and make it read:

f5/f7+g5/g7+h5/h7

not:

f5/f8+g5/g8+h5/h8

How do I do this? There has to be a way.
 
You need to put in absolute references for the bits you don't want t
change. These are shown with the $ sign.

In your example copying +f4/f7 down one row would result in +f5/f8

+f4/f$7 would give you +f5/f$7 in the next row down.

similarly +f4/f7 copied right would give +g4/g7 but +f4/$f7 would giv
+g4/$f7

for more info look in the help for "the difference between relative an
absolute references" which can be found by searching for "absolut
references
 
Sandra,

Adjust the original formula to read:

f4/$f$7+g4/$g$7+h4/$h$7

Then when you drag the formula, it will become:

f5/$f$7+g5/$g$7+h5/$h$7

Hope this helps,
Katie
 
Back
Top