Copying Formulas

[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.

 

[Alex Delamain]

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

 

[Guest]

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